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
Mehedad Posts 22 Registration date Thursday April 19, 2012 Status Member Last seen April 16, 2013 - Apr 19, 2012 at 05:40 AM
Related:
- Help please on Excel Search
- Www.google.com search video - Download - Video playback
- Yahoo search history - Guide
- How to search words on a page - Guide
- Excel date format dd.mm.yyyy - Guide
- Safe search settings - Guide
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
Apr 18, 2012 at 05:45 AM
you can use vlookup
Mehedad
Posts
22
Registration date
Thursday April 19, 2012
Status
Member
Last seen
April 16, 2013
3
Apr 19, 2012 at 05:40 AM
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.
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.
