Using Vlookup as "value_if_true" in IF function

D

dark_snowboy

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?
 
P

paul

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 -
 
B

Biff

Hi!
=IF(F12=F3:F8,"=VLOOKUP($F$12,$F$3:$L$8,7,FALSE)","-")
Click to expand...

F12=F3:F8

This is an array and in order for it to evaluate as TRUE, you'd have to
enter the formula as an array and every cell in the array, F3:F8, would
have to equal F12.

Maybe you want something like this:

=IF(COUNTIF(F3:F8,F12),VLOOKUP(F12,F3:L8,7,0),"-")

Biff

"dark_snowboy" <[email protected]>
wrote in message
 
P

paul

Biff(not wanting to hijack thread) if i enter {=f12=f3:f8} with ctrl shift
enter it behaves exactly as you say,but {=f3:f8=f12} with ctrl shift enter
doesnt it only seems to evaluate f3......
 
Top