Thread: Using Vlookup as "value_if_true" in IF function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dark_snowboy
 
Posts: n/a
Default Using Vlookup as "value_if_true" in IF function

I wonder if it is possible?

=IF(F12=F3:F8,"=VLOOKUP($F$12,$F$3:$L$8,7,FALSE)", "-")

I can confirm that my vlookup function and logical test is correct.
Or is there a problem with the absolute cell reference that i used?


--
dark_snowboy
------------------------------------------------------------------------
dark_snowboy's Profile: http://www.excelforum.com/member.php...o&userid=30466
View this thread: http://www.excelforum.com/showthread...hreadid=505236

Reply With QuoteReply With Quote