I see a exclamation mising in the second VLOOKUP (!)

=IF(ISNA(VLOOKUP(A36,
'H\VHIS MANUAL PROCEDURES\[TRUST ACCOUNTS TEMPLATE.XLS]MEMBER
LIST'!$A$4:$I$100,9,FALSE)),"",
VLOOKUP(A36,
'H\VHIS MANUAL PROCEDURES\[TRUST ACCOUNTS TEMPLATE.XLS]MEMBER
LIST'!$A$4:$I$100,9,FALSE))

If this post helps click Yes
---------------
Jacob Skaria


"Marysam67" wrote:

I am using this formula for a vlookup with blank reference cells. Can you
tell me what is wrong with this formula. I get an error message.

=IF(ISNA(VLOOKUP(A36,'H\VHIS MANUAL PROCEDURES\[TRUST ACCOUNTS
TEMPLATE.XLS]MEMBER LIST'!$A$4:$I$100,9,FALSE)),"",VLOOKUP(A36,'H\VHIS MANUAL
PROCEDURES\[TRUST ACCOUNTS TEMPLATE.XLS]MEMBER LIST'$A$4:$I$100,9,FALSE))

Thank you.