Help please on Excel Search

Closed
Toni - Apr 18, 2012 at 04:21 AM
Mehedad
Posts
22
Registration date
Thursday April 19, 2012
Status
Member
Last seen
April 16, 2013
- Apr 19, 2012 at 05:40 AM
Hello,

Need your expert opinion on what formula i should use. Quite new using excel.

Scenario:
A | B | C | D |
1 | 123 | Aime | Burt | 456
2 | 456 | Burt | Ali | 789
3 | 789 | Ali | Aime | 123
4 | 012 | Bem | Bem |012

I have cell A1 with 123 value corresponding to Aime, A2: 456: Burt and so on. I want to know if there is a certain formula that when i type Burt in Cell C1, it will display the id of the person (456).


Thanks a lot.

3 replies

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Apr 18, 2012 at 05:45 AM
you can use vlookup
0
Thanks, any formula please..
0
Mehedad
Posts
22
Registration date
Thursday April 19, 2012
Status
Member
Last seen
April 16, 2013
3
Apr 19, 2012 at 05:40 AM
for that to happen, you have to rearrange your data a bit (to use VLOOKUP.

Put ID the Second Column and the Name in the First Column
Write this Formula in the Fourth Column:
=IF(C2<>"",VLOOKUP(C2,A:B,2,FALSE),"")
Column C is where you type in the name to be found

Its good to sort the Names in ascending order before you apply the formula.

There are other ways to do it without VLOOKUP, but I am not familiar with those formulas (look for Index Match functions if you don't want to change the format of the columns).

Hope it will help.
0