R
Richard
Please can anyone help! Sheet 2 has a list of different numbers in column A
with other info pertaining to that number in columns B, C, D. I need whenever
that specific number is input on Sheet1 for it to calcuate the info thats
also in columns B,C,D. Example: RT-005 has a qty of 20 in column B, a qty of
1 in column C, a qty of 3 in column D. This info never changes! On sheet 1
whenever I type in RT-005 I want a formula to calculate columns B,C,D on
sheet2 and send results to column C on sheet1 wherever RT-005 in typed in.
Formula is: B2(sheet2)/B2(sheet1)/C2(sheet2)*D2(sheet2) Thanks in Advance !!!
with other info pertaining to that number in columns B, C, D. I need whenever
that specific number is input on Sheet1 for it to calcuate the info thats
also in columns B,C,D. Example: RT-005 has a qty of 20 in column B, a qty of
1 in column C, a qty of 3 in column D. This info never changes! On sheet 1
whenever I type in RT-005 I want a formula to calculate columns B,C,D on
sheet2 and send results to column C on sheet1 wherever RT-005 in typed in.
Formula is: B2(sheet2)/B2(sheet1)/C2(sheet2)*D2(sheet2) Thanks in Advance !!!