VLOOKUP question

  • Thread starter Thread starter Jonah
  • Start date Start date
J

Jonah

How do I lookup from column A and B so that the resultant answers are
put in columns D and E? I can do a single element Vlookup but not sure
about two columns of lookup.

I have Surname, Forename, Age, House name in my table.

If I key in a surname, I want the system to check for a single
occurrence of the forename to prevent duplicate names. It then must
give me the age of the person and also their house name.

e.g. Smith, Jimmy,23,The Gables

Jonah
 
Let's say your header in A1:D1
A1 =Surname
B1 =Forename
C1 =Age
D1 =House name

Criteria in
F1 =Smith
G1 =Jimmy

Searching for Age:
H1 =INDEX(C1:C100,MATCH(1,(A1:A100=F1)*(B1:B100=G1),0))
ctrl>shift>enter (not just enter)

Searching for House name
I1 =INDEX(D1:D100,MATCH(1,(A1:A100=F1)*(B1:B100=G1),0))
ctrl>shift>enter (not just enter)
 

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

splitting forenames/surnames into separate columns 2
Not exactly a transpose problem 5
how do i convert names to initials in excel 2
Excel Comparing two columns 1
Extract surname from forenames 7
Returning matched employee number from a different sheet 2
Error in Copying "Exact" Function 1
Linq and xml question 2

Back
Top