Compare 2 columns on 2 sheets for value of cell

Closed
Report
-
Posts
10
Registration date
Monday March 21, 2016
Status
Member
Last seen
May 11, 2016
-
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!!!!

1 reply

Posts
10
Registration date
Monday March 21, 2016
Status
Member
Last seen
May 11, 2016

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