Look up name in column return info next cell over

tgreene2856

New Member
Joined
Apr 10, 2013
Messages
28
I am looking for a formula to search a column for a name then when found give me the data the cell next to it.


Example:



A
B
1
Name
Age
2
Tim
18
3
Kelly
22
4
Josh
19

<tbody>
</tbody>




Search Column A for Kelly it finds it ins A3 but the result returned is from B3 which would be 22.

Being able to have the formula repeated in the same cell to add multiple rows for the name would be helpful as well.


Thanks


Tim
 

L. Howard

Well-known Member
Joined
Oct 16, 2012
Messages
4,514
Being able to have the formula repeated in the same cell to add multiple rows for the name would be helpful as well.
Hi Tim,

=VLOOKUP(C1,$A$2:$B$4,2,0)

Where you would enter the name in C1.

I don't understand the second part.

Howard
 

Forum statistics

Threads
1,085,990
Messages
5,387,136
Members
402,045
Latest member
Hidalgo

Some videos you may like

This Week's Hot Topics

Top