Excel: locate value in one list & copy
Solved/Closed
Related:
- Excel: locate value in one list & copy
- Transfer data from one excel worksheet to another automatically - Guide
- Excel date format dd.mm.yyyy - Guide
- Contact number list - Guide
- Number to words in excel - Guide
- How to find a list of names in excel ✓ - Excel Forum
1 reply
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
Jul 19, 2010 at 12:21 PM
Jul 19, 2010 at 12:21 PM
you can use vlookup
Lets say List 1 is between col A-C and list 2 is column D-E
then in C2 you can have
=IF(ISERROR(VLOOKUP(A2, D:E, 2, false)), ".", VLOOKUP(A2, D:E, 2, false))
and just drag it down
Lets say List 1 is between col A-C and list 2 is column D-E
then in C2 you can have
=IF(ISERROR(VLOOKUP(A2, D:E, 2, false)), ".", VLOOKUP(A2, D:E, 2, false))
and just drag it down
Jul 19, 2010 at 01:20 PM
It works perfectly.
Oct 26, 2011 at 06:31 PM