Compare 2 sets of cells over different worksheets and return a value in a different cell

[daniel12346]

Hello,

Trying to get a value into sheet A from a cell in either sheet B or C where a cell on either sheet B or C equals a certain cell on sheet A.

I have attached the workbook to understand better. Comments are in the summary sheet in cells C13 & E13.

Would be so grateful if anyone could help me with a forumla to sort this out.

Thanks,

Daniel

[JeteMc]

I don't believe that what you want is possible using formulas, however it appears to me that the text in B13:B48 on the summary sheet closely matches the sheet names. If you want to get the contractor name from a particular sheet name I feel that the INDIRECT function would work, providing the sheet names and text values match.
I.E. if there was a contractor name in cell D5 of the GWKS sheet and if Summary B13 read GWKS then you could use: =INDIRECT("'"&B13&"'!D5")
Let us know if you have any questions.

[daniel12346]

I can just change the sheet names to match the text in the summary sheet and that formula works, thank you!

Most appreciated!

[JeteMc]

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.