Formula to show value from other sheet if matching cell

[tomcatprime]

Hello Everyone,
I am trying to make a formula that will show me a value from sheet2 in my sheet1 if is match to cell E2
show.png
Thank you for your help in advance

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook. Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

[tomcatprime]

Okay, I will extract and add as workbook

[tomcatprime]

workbook.xlsx
workbook attached

[JeteMc]

Try the following:
For value 1: =OFFSET(INDIRECT("Sheet2!"&ADDRESS(MATCH($E$1,Sheet2!$B$1:$B$61,0),2)),2,6)
For value 2: =OFFSET(INDIRECT("Sheet2!"&ADDRESS(MATCH($E$1,Sheet2!$B$1:$B$61,0),2)),2,8)
Let us know if you hae any questions.

[tomcatprime]

Working perfectly!!
Thank you so much for your help!

[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.

[Glenn Kennedy]

I would try to avoid using INDIRECT, it can cause performance issues, as it recalculates evey time anything changes:

=INDEX(Sheet2!H:H,MATCH($E$1,Sheet2!$B:$B,0)+2)

and

=INDEX(Sheet2!J:J,MATCH($E$1,Sheet2!$B:$B,0)+2)