Excel: locate value in one list & copy
Solved/Closed
Related:
- Excel: locate value in one list & copy
- Excel marksheet - Guide
- Number to words in excel - Guide
- Excel apk for pc - Download - Spreadsheets
- Kernel for excel - Download - Backup and recovery
- Excel date format dd.mm.yyyy - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
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