Excel Problem: VLookup

  • Thread starter Thread starter andyp161
  • Start date Start date
A

andyp161

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
 
Hi
try the following array formula (entered with CTRL+SHIFT+ENTER):
=INDEX(C1:C100,MATCH(1,(A1:A100="surname")*(B1:B100="firstname"),0))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicate 2
vlookup / index / match? 5
Help With VLOOKUP 2
Vlookup to reference offset 1
Please help me with VLOOKUP AP 6
Embedding vlookup 4
Vlookup and return sheet name also 2
Scrabble Value calculation for Welsh words 0

Back
Top