View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Marysam67 Marysam67 is offline
external usenet poster
 
Posts: 7
Default 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.