Help with If formula

[troyakaTB]

I have this formual that shows values from one sheet to another "=INDEX(Sheet1!3:3,MATCH(G$1,Sheet1!$1:$1,0))". THe formula returns a #N/A becasue some of the values are not available yet. This is okay becasue they will be later. I would like to use a an IF formula in conjustion wih the above formula to show either a blank cell"" of just return a zero if some of the values are missing. I am not sure what arguement I need to put first in the IF formula to accomplish this. Thanks for the help.

TB

[singerj6]

try =IF(ISERROR(INDEX(Sheet1!3:3,MATCH(G$1,Sheet1!$1:$1,0)),"What you want to show up if its an error",INDEX(Sheet1!3:3,MATCH(G$1,Sheet1!$1:$1,0))

[tigeravatar]

Alternate:
=IF(ISNA(MATCH(G$1,Sheet1!$1:$1,0)),"",HLOOKUP(G$1,Sheet1!$1:3,ROWS($1:3),0))

[troyakaTB]

Thanks for the help, ISERROR worked.