Excel - IF(ISNA

[dhamDIT]

Hi, I have tried several different options of trying to fit the IF(ISNA into my formula without success. I think I am getting the brackets wrong. Here is my formula. Any help is appreciated.
Thanks D

=INDEX(Sheet1!$AE$1:$AE$31,MATCH($B3,Sheet1!AF$1:AF$32))

 

[GlennUK]

Test the MATCH like this:

=IF(ISNA(MATCH($B3,Sheet1!AF$1:AF$32,0),"",INDEX(Sheet1!$AE$1:$AE$31,MATCH($B3,Sheet1!AF$1:AF$32,0)))

BTW, I have added the 3rd argument of 0 in MATCH ... to look for exact match.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[GlennUK]

Missing right bracket

=IF(ISNA(MATCH($B3,Sheet1!AF$1:AF$32,0)),"",INDEX(Sheet1!$AE$1:$AE$31,MATCH($B3,Sheet1!AF$1:AF$32,0)))



Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[KenWright]

General syntax

=IF(ISNA(Your_Formula),"",Your_Formula)

Regards
Ken............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------