software

I wonder if it is possible?

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

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: www.excelforum.com/member.php...oamp;userid=30466
View this thread: www.excelforum.com/showthread...hreadid=505236i 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), quot;-quot;),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!
quot;dark_snowboyquot; wrote:

gt;
gt; I wonder if it is possible?
gt;
gt; =IF(F12=F3:F8,quot;=VLOOKUP($F$12,$F$3:$L$8,7,FALSE)quot;, quot;-quot;)
gt;
gt; I can confirm that my vlookup function and logical test is correct.
gt; Or is there a problem with the absolute cell reference that i used?
gt;
gt;
gt; --
gt; dark_snowboy
gt; ------------------------------------------------------------------------
gt; dark_snowboy's Profile: www.excelforum.com/member.php...oamp;userid=30466
gt; View this thread: www.excelforum.com/showthread...hreadid=505236
gt;
gt;

Hi!

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

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),quot;-quot;)

Biff

quot;dark_snowboyquot; gt;
wrote in message
news:dark_snowboy.228chy_1138258800.9796@excelforu m-nospam.com...
gt;
gt; I wonder if it is possible?
gt;
gt; =IF(F12=F3:F8,quot;=VLOOKUP($F$12,$F$3:$L$8,7,FALSE)quot;, quot;-quot;)
gt;
gt; I can confirm that my vlookup function and logical test is correct.
gt; Or is there a problem with the absolute cell reference that i used?
gt;
gt;
gt; --
gt; dark_snowboy
gt; ------------------------------------------------------------------------
gt; dark_snowboy's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30466
gt; View this thread: www.excelforum.com/showthread...hreadid=505236
gt;
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!
quot;Biffquot; wrote:

gt; Hi!
gt;
gt; gt; =IF(F12=F3:F8,quot;=VLOOKUP($F$12,$F$3:$L$8,7,FALSE)quot;, quot;-quot;)
gt;
gt; F12=F3:F8
gt;
gt; This is an array and in order for it to evaluate as TRUE, you'd have to
gt; enter the formula as an array and every cell in the array, F3:F8, would
gt; have to equal F12.
gt;
gt; Maybe you want something like this:
gt;
gt; =IF(COUNTIF(F3:F8,F12),VLOOKUP(F12,F3:L8,7,0),quot;-quot;)
gt;
gt; Biff
gt;
gt; quot;dark_snowboyquot; gt;
gt; wrote in message
gt; news:dark_snowboy.228chy_1138258800.9796@excelforu m-nospam.com...
gt; gt;
gt; gt; I wonder if it is possible?
gt; gt;
gt; gt; =IF(F12=F3:F8,quot;=VLOOKUP($F$12,$F$3:$L$8,7,FALSE)quot;, quot;-quot;)
gt; gt;
gt; gt; I can confirm that my vlookup function and logical test is correct.
gt; gt; Or is there a problem with the absolute cell reference that i used?
gt; gt;
gt; gt;
gt; gt; --
gt; gt; dark_snowboy
gt; gt; ------------------------------------------------------------------------
gt; gt; dark_snowboy's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=30466
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=505236
gt; gt;
gt;
gt;
gt;

Hi

It looks like this will do

=IF(ISNA(VLOOKUP($F$12,$F$3:$L$8,7,0)),quot;-quot;,VLOOKUP($F$12,$F$3:$L$8,7,0))--
Arvi Laanemets
( My real mail address: arvi.laanemetslt;atgt;tarkon.ee )
quot;dark_snowboyquot; gt;
wrote in message
news:dark_snowboy.228chy_1138258800.9796@excelforu m-nospam.com...
gt;
gt; I wonder if it is possible?
gt;
gt; =IF(F12=F3:F8,quot;=VLOOKUP($F$12,$F$3:$L$8,7,FALSE)quot;, quot;-quot;)
gt;
gt; I can confirm that my vlookup function and logical test is correct.
gt; Or is there a problem with the absolute cell reference that i used?
gt;
gt;
gt; --
gt; dark_snowboy
gt; ------------------------------------------------------------------------
gt; dark_snowboy's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30466
gt; View this thread: www.excelforum.com/showthread...hreadid=505236
gt;