# 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.
Related:

## 3 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 18, 2012 at 05:45 AM
you can use vlookup
Thanks, any formula please..
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.