aligahk06
04-03-2010, 07:20 AM
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
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