Thread: vlookup
View Single Post
  #1   Report Post  
Jimat56
 
Posts: n/a
Default vlookup

I need a way of testing the return value from a vlookup call.
It will happen that the lookup will fail and the return will be #N/A, which
is not nicest thing to see on a spreadsheet! I have tried "if" statement
variations but testing the cell is unsuccessful as the 'value'of the cell is
not what is displayed!

Jim Crawford
Alden Press
Oxford UK