Using Vlookup as "value_if_true" in IF function

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

It showed a #VALUE! error.

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


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

[Biff]

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

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

[Arvi Laanemets]

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<at>tarkon.ee )



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