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

Using Vlookup as "value_if_true" in IF function
 

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

Using Vlookup as "value_if_true" in IF function
 

Hi!

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

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"
wrote in message
news:dark_snowboy.228chy_1138258800.9796@excelforu m-nospam.com...

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

Using Vlookup as "value_if_true" in IF function
 

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......
--
paul
remove nospam for email addy!



"Biff" wrote:

Hi!

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

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"
wrote in message
news:dark_snowboy.228chy_1138258800.9796@excelforu m-nospam.com...

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

Using Vlookup as "value_if_true" in IF function
 

Hi

It looks like this will do

=IF(ISNA(VLOOKUP($F$12,$F$3:$L$8,7,0)),"-",VLOOKUP($F$12,$F$3:$L$8,7,0))


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"dark_snowboy"
wrote in message
news:dark_snowboy.228chy_1138258800.9796@excelforu m-nospam.com...

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