Hello Guys,
Can You please help me with following,
I have in sheet 1
A1="DATE" B1="CODE" C1="ACC CODE"
A2="1-11" B2="B1" C2="CAP"
A3="2-11" B3="B2" C3="MT"
A4="3-11" B4="B3" C4="MT"
A5="4-11" B5="B4" C5="OE"
In Sheet2 I have
B1="MATERIAL"
A2="DATE" B2="CODE" C1="ACC CODE"
B6="OFF EXP"
A7="DATE" B7="CODE" C7="ACC CODE"
what i want is If I enter the ACC Code in Sheet2 in ( C2 )
The other 2 data that is CODE & DATE should be copied from SHEET1
I have used the INDEX function but it only copies the third row everytime.It does not goes further.
Can You please help me with following,
I have in sheet 1
A1="DATE" B1="CODE" C1="ACC CODE"
A2="1-11" B2="B1" C2="CAP"
A3="2-11" B3="B2" C3="MT"
A4="3-11" B4="B3" C4="MT"
A5="4-11" B5="B4" C5="OE"
In Sheet2 I have
B1="MATERIAL"
A2="DATE" B2="CODE" C1="ACC CODE"
B6="OFF EXP"
A7="DATE" B7="CODE" C7="ACC CODE"
what i want is If I enter the ACC Code in Sheet2 in ( C2 )
The other 2 data that is CODE & DATE should be copied from SHEET1
I have used the INDEX function but it only copies the third row everytime.It does not goes further.