Picking respective value from different col based on a particular value input.

[aligahk06]

Dear All,

Attached file is for ur ref.
In sheet Lineitem I have plugged some value in different column.
In sheet2 if i put in Cell A3 1.1.160 then automatically display in D3 ELBOW 1" and in clumn H3 3.23.
i.e Based on Cell A3 i want a formula that yield the respective value of D3 and H3 based on Sheet LineItem,
I mean pickng the value from Lineitem sheet and disply in corresponding cell.
Hope u understand my query?

Rgds,
Aligahk06

[Bob Phillips]

=INDEX(LineItem!$D:$D,MATCH(Sheet2!$A3,LineItem!$H:$H,0))

and

=INDEX(LineItem!$I:$I,MATCH(Sheet2!$A3,LineItem!$H:$H,0))