• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Way over my head! Vlookup and if/then

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!
 

Attachments

  • Wean Projections.xlsx
    623.9 KB · Views: 0
Back
Top