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!

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!