Help please on Excel Search

[Closed]
Report
-
Posts
22
Registration date
Thursday April 19, 2012
Status
Member
Last seen
April 16, 2013
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
you can use vlookup
Thanks, any formula please..
Posts
22
Registration date
Thursday April 19, 2012
Status
Member
Last seen
April 16, 2013
3
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.