VLOOKUP question

[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

 

[Guest]

Let's say your header in A11
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(D1100,MATCH(1,(A1:A100=F1)*(B1:B100=G1),0))
ctrl>shift>enter (not just enter)