Excel Problem: VLookup
 

Hi there,

When using Vlookup, is it possible to use a lookup value in 2 adjacent
cells i.e the lookup values I am using are people's surnames, but where
people have the same surname vlookup does not work. Therefore, I want
to be able to use a1:b1 as a lookup value that will contain the
forename in a1 and the surname in b1 - howeverm this does not seem to
work??

Many thanks


--
andyp161
------------------------------------------------------------------------
andyp161's Profile: http://www.excelforum.com/member.php...o&userid=11654
View this thread: http://www.excelforum.com/showthread...hreadid=314831

Hi
try the following array formula (entered with CTRL+SHIFT+ENTER):
=INDEX(C1:C100,MATCH(1,(A1:A100="surname")*(B1:B10 0="firstname"),0))

"andyp161" wrote:


Hi there,

When using Vlookup, is it possible to use a lookup value in 2 adjacent
cells i.e the lookup values I am using are people's surnames, but where
people have the same surname vlookup does not work. Therefore, I want
to be able to use a1:b1 as a lookup value that will contain the
forename in a1 and the surname in b1 - howeverm this does not seem to
work??

Many thanks


--
andyp161
------------------------------------------------------------------------
andyp161's Profile: http://www.excelforum.com/member.php...o&userid=11654
View this thread: http://www.excelforum.com/showthread...hreadid=314831