i dont think F12=F3:F8 is quite correct(or is this where you need ctrl shift
enter????)
,and the lookup function doesnt need to be in quotes
=IF(F12=(F3:F8),=VLOOKUP($F$12,$F$3:$L$8,7,FALSE), "-"),or is this where you
need ctrl shift enter????
So if the logical test is true you get the lookup otherwise -


--
paul
remove nospam for email addy!



"dark_snowboy" wrote:


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