lesmccuist
New Member
I am in way over my head here with trying to write a complex formula and am looking for a quick solution. Help! I am wanting to look up data in multiple sheets and if I find a match return an answer from the same column different row. I want to look up the number in row 1 on Sheet 2 across all worksheets. If it finds the number, I want to place the answer in cell B3. The answer would be located in row 47 of the corresponding column.
Example: Sheet 2 B1 = 980, Sheet Wk 27 has 980 in B8. I want to return an answer from cell B47 (Sheet Wk 27) to Sheet 2 cell B3.
Thank you!
Example: Sheet 2 B1 = 980, Sheet Wk 27 has 980 in B8. I want to return an answer from cell B47 (Sheet Wk 27) to Sheet 2 cell B3.
Thank you!