Multiple VLOOKUPs

[Kolja]

I need to do following:
When user enters name in one text box, Excel searches for entry in one column, and displays city from another column via VLOOKUP function.
=VLOOKUP (B1;23:65536;2;FALSE)
What if there are two persons with same name?
I could allow users to enter their birth date, so if program finds several entries, it should check birth date from third column.
How to tell VLOOKUP function to search for lookup_value in third column?
If that's possible, how to connect these two functions, so that they work as one?
Is there any other function that might check these two values from first and third column and display value from second column?

 

[Frank Kabel]

Hi
if column A stores the name and column B the birthdate and you want to
return the value from column C you may try something like the following
array formula (entered with CTRL+SHIFT+ENTER)
=INDEX(C1:C1000,MATCH(0,(A1:A1000="name1")*(B1:B1000=DATE(1970,4,13)),0
))

 

[Domenic]

Hi Kolja,

Assuming that Column A contains your names, Column B contains your
cities, and Column C the date of births, try:

=INDEX(B2:B10,MATCH(1,(A2:A10=E1)*(C2:C10=E2),0))

to be entered using CTRL+SHIFT+ENTER.

Where E1 houses the name and E2 the date of birth.

Hope this helps!

 

[Kolja]

Stupid mouse...

Mmm, yes, thank you!
It worked, Domenic!
Thank you very much, both of you!