Search word from list, match it copy values next to it
Solved/Closed
haris1989
Posts
2
Registration date
Monday 31 August 2015
Status
Member
Last seen
31 August 2015
-
31 Aug 2015 à 11:48
haris1989 Posts 2 Registration date Monday 31 August 2015 Status Member Last seen 31 August 2015 - 31 Aug 2015 à 12:30
haris1989 Posts 2 Registration date Monday 31 August 2015 Status Member Last seen 31 August 2015 - 31 Aug 2015 à 12:30
Related:
- Search word from list, match it copy values next to it
- Google search from usa - Guide
- Ms word pdf extension - Download - Other
- How to search for a word on a web page chrome - Guide
- Yahoo search history - Guide
- Counter strike 1.6 cheats list - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
31 Aug 2015 à 12:04
31 Aug 2015 à 12:04
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


31 Aug 2015 à 12:30