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!!!!