Help please on Excel Search
Closed
Toni
-
18 Apr 2012 à 04:21
Mehedad Posts 22 Registration date Thursday 19 April 2012 Status Member Last seen 16 April 2013 - 19 Apr 2012 à 05:40
Mehedad Posts 22 Registration date Thursday 19 April 2012 Status Member Last seen 16 April 2013 - 19 Apr 2012 à 05:40
Related:
- Help please on Excel Search
- Excel mod apk for pc - Download - Spreadsheets
- Yahoo search history - Guide
- Search nearby friends on facebook - Guide
- Vim search - Guide
- Google search from usa - Guide
3 responses
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
18 Apr 2012 à 05:45
18 Apr 2012 à 05:45
you can use vlookup
Mehedad
Posts
22
Registration date
Thursday 19 April 2012
Status
Member
Last seen
16 April 2013
3
19 Apr 2012 à 05:40
19 Apr 2012 à 05:40
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.
