Hello, I think this is an index match question. I have 2 sheets and I'm trying to bring in the value from sheet 2 to sheet 1.
Attached on sheet one in cell P2, I want to find the value in cell A2 on sheet 2 (in column E) and bring in the value from column C.
On my attached template, in sheet 1, I want to look for "123456" on sheet 2 column E and bring in the corresponding value from that row "103323" in column C onto sheet 1 column P.
I'm pretty sure this is an index match? Not sure what the formula would be.
Any assistance would be greatly appreciated
Bookmarks