Hello, please help in fixing error related to combintion of IF and choose function below : I have used used choose function to extract data from 4 diff sheets =CHOOSE($H$3,sheet1!A2,sheet2!A2,sheet3!A2,sheet4!A2). Now, I want to use "IF" function with CHOOSE to replace the false results with "". But it's not working, please let me know is there any problem with syntax below.
 
=IF(CHOOSE($H$3,sheet1!A2,sheet2!A2,sheet3!A2,sheet4!A2),CHOOSE($H$3,sheet1!A2,sheet2!A2,sheet3!A2,sheet4!A2),"")