You seem to have qty in Column B and in Column C. How do you compute the end
result? What is your formula?

Tyro

"Richard" wrote in message
...
whenever I type in this number on sheet1, Lookup RT-005 0n sheet2 Column
A,
match qty in column B with RT-005 in column A, Take qty in column C, Run
time
in column D, number of machines in column E. End result is total hours to
complete. Thanks in advance!