I am trying to create a spreadsheet that will allow a technician to enter the info for a specific machine, when he does this, excel will go to a second spreadsheet, find the relative info from the original machine and convert it to meet the specifications of the new machine the technician wants to put the job into. I have attached the worksheets along with comments in the specific cells that I need the look up and the formula to work in. thanks.
Bookmarks