Compare 2 columns on 2 sheets for value of cell
Closed
Kyna
-
May 4, 2016 at 05:44 PM
Newmie2013 Posts 10 Registration date Monday March 21, 2016 Status Member Last seen May 11, 2016 - May 9, 2016 at 09:56 AM
Newmie2013 Posts 10 Registration date Monday March 21, 2016 Status Member Last seen May 11, 2016 - May 9, 2016 at 09:56 AM
I have tried several different formulas and cannot seem to get it right.
I have a work book with 2 sheets. I am trying to populate column E of sheet 1. To do so, want to compare the values in sheet 1, column A to the values in sheet 2, column A. If a value matches exactly, then I would like the value that appears further down the row in column S of sheet 2 to auto-populate the corresponding cell in sheet 1, column E.
Example: To populate the cell sheet 1, E6.
The value in sheet 1, A6 is 111. On sheet 2, 111 also appears in cell A23. Therefore I would like the value in cell S23 sheet 2 (which is calculated through a formula on sheet 2) to appear in cell E6 on sheet 1.
Any ideas? Is this possible with multiple sheets? I appreciate any help!!!!
I have a work book with 2 sheets. I am trying to populate column E of sheet 1. To do so, want to compare the values in sheet 1, column A to the values in sheet 2, column A. If a value matches exactly, then I would like the value that appears further down the row in column S of sheet 2 to auto-populate the corresponding cell in sheet 1, column E.
Example: To populate the cell sheet 1, E6.
The value in sheet 1, A6 is 111. On sheet 2, 111 also appears in cell A23. Therefore I would like the value in cell S23 sheet 2 (which is calculated through a formula on sheet 2) to appear in cell E6 on sheet 1.
Any ideas? Is this possible with multiple sheets? I appreciate any help!!!!
Related:
- Compare 2 columns on 2 sheets for value of cell
- Tentacle locker 2 - Download - Adult games
- Feeding frenzy 2 download - Download - Arcade
- Call of duty modern warfare 2 2022 free download - Download - Shooters
- Fnia 2 - Download - Adult games
- My cute roommate 2 - Download - Adult games
1 response
Newmie2013
Posts
10
Registration date
Monday March 21, 2016
Status
Member
Last seen
May 11, 2016
May 9, 2016 at 09:56 AM
May 9, 2016 at 09:56 AM
Sounds like you Need a Standard VLookup:
In Sheet 1, E6 Type: =Vlookup(A6;Sheet2!A:A;1;False)
This should do it...
Regards,
Newmie
In Sheet 1, E6 Type: =Vlookup(A6;Sheet2!A:A;1;False)
This should do it...
Regards,
Newmie