Finding data

F

Finder2000

I have a list like this

Name Telephone
John 546666
Paul 4422554
John 542245
Joseph 4562354

How can I get in a cell the las telephone number of john if I write "John"
in a cell?
Thanks a lot
 
B

Biff

Hi!

Try this:

Names in col A, numbers in col B.

C1 = John

=LOOKUP(2,1/(A1:A5=C1),B1:B5)

Biff
 
Top