software

Hi

I want to carry out a Vertical Lookup but the Lookup Value is contained
in 2 columns. Can this be done or would it be best to Concatenate the 2
columns into one?

Thanks

Shirley Munro--
Shirley Munro
------------------------------------------------------------------------
Shirley Munro's Profile: www.excelforum.com/member.php...nfoamp;userid=836
View this thread: www.excelforum.com/showthread...hreadid=493021
Without a specific example, it's difficult to give you specific help...

Meanwhile, I believe this website will get you headed in the right
direction:

www.xldynamic.com/source/xld.SUMPRODUCT.htmlI hope that helps.

Regards,
Ron--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: www.excelforum.com/member.php...oamp;userid=21419
View this thread: www.excelforum.com/showthread...hreadid=493021Do you mean that you want to match based on the input in two columns?

If yes...

You can use this kind of syntax:

=index(othersheet!$c$1:$c$100,
match(1,(a2=othersheet!$a$1:$a$100)*(b2=othersheet !$b$1:$b$100),0))
(one cell)

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

Adjust the range to match--but you can't use the whole column.

Shirley Munro wrote:
gt;
gt; Hi
gt;
gt; I want to carry out a Vertical Lookup but the Lookup Value is contained
gt; in 2 columns. Can this be done or would it be best to Concatenate the 2
gt; columns into one?
gt;
gt; Thanks
gt;
gt; Shirley Munro
gt;
gt; --
gt; Shirley Munro
gt; ------------------------------------------------------------------------
gt; Shirley Munro's Profile: www.excelforum.com/member.php...nfoamp;userid=836
gt; View this thread: www.excelforum.com/showthread...hreadid=493021

--

Dave Peterson

I vote for the CONCATENATION option...........I use it all the time.

Vaya con Dios,
Chuck, CABGx3
quot;Shirley Munroquot; wrote:

gt;
gt; Hi
gt;
gt; I want to carry out a Vertical Lookup but the Lookup Value is contained
gt; in 2 columns. Can this be done or would it be best to Concatenate the 2
gt; columns into one?
gt;
gt; Thanks
gt;
gt; Shirley Munro
gt;
gt;
gt; --
gt; Shirley Munro
gt; ------------------------------------------------------------------------
gt; Shirley Munro's Profile: www.excelforum.com/member.php...nfoamp;userid=836
gt; View this thread: www.excelforum.com/showthread...hreadid=493021
gt;
gt;