Search word from list, match it copy values next to it
Solved/Closed
haris1989
haris1989
- Posts
- 2
- Registration date
- Monday August 31, 2015
- Status
- Member
- Last seen
- August 31, 2015
haris1989
- Posts
- 2
- Registration date
- Monday August 31, 2015
- Status
- Member
- Last seen
- August 31, 2015
Related:
- Search word from list, match it copy values next to it
- Vim search word - Guide
- How to search word in google - Guide
- Search word in pdf online - Guide
- How to search word in mac - Guide
- Search for multiple substrings and return different values ✓ - Forum - Excel
1 reply
TrowaD
Aug 31, 2015 at 12:04 PM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Aug 31, 2015 at 12:04 PM
Hi Haris,
Good thing you stopped after manually inputting 4 rows.
VLOOKUP is the formula you are looking for. Write 1 formula for the D column and one for the E column and then drag both down.
Do let us know if you can't get it to work.
Best regards,
Trowa
Good thing you stopped after manually inputting 4 rows.
VLOOKUP is the formula you are looking for. Write 1 formula for the D column and one for the E column and then drag both down.
Do let us know if you can't get it to work.
Best regards,
Trowa
Aug 31, 2015 at 12:30 PM