VLOOKUP WITH BLANK REFERENCE CELLS
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.
|