Thread: simple lookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Max_power
 
Posts: n/a
Default simple lookup


Hello,

I'm trying to do a simple Vlookup that will return the number or return
"not found" if not found. So if it's nan it will return "not found".
I can't seem to get my if statement correct


Many thanks


--
Max_power
------------------------------------------------------------------------
Max_power's Profile: http://www.excelforum.com/member.php...o&userid=32255
View this thread: http://www.excelforum.com/showthread...hreadid=534891