View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nastech
 
Posts: n/a
Default VLOOKUP Question..

ahhh.. had that happen before, similar answer to (what do you call it?) a
double negative? guesse I call it a double-whamy twice over.. thanks !!

"flummi" wrote:

Sorry, withouth the equel sign in the middle.

=if(isna(VLOOKUP(V124,[file.xls]sheet!$A$1:$B$3355,2,FALSE)),"",VLOOKUP(V1Â*24,[file.xls]sheet!$A$1:$B$3355,2,FALSE))


Hans