H Look Up (I need Horizontal look up)

[pmw19800]

Hello All

Please see attahed

In R2 on tab 1 - I need this to return from shee1 (row 25….based on the part number in row 1)

Expected resuts in yellow

cheers

[davesexcel]

Try this

Please Login or Register  to view this content.

Index/match would work as well

Please Login or Register  to view this content.

[CARACALLA]

Tab1

R2=IFERROR(INDEX(Sheet1!$B$25:$J$25,,MATCH('Tab1'!$E2,Sheet1!$B$1:$J$1,0)),"")

copy down

[Bo_Ry]

Please try at R2
=HLOOKUP(E2,Sheet1!$B$1:$J$101,25,0)

[pmw19800]

thanks All,

works perfect now