Excel Help.jpg
See above for simplified format.
I was having some problems and I have tried using the vlookup/hlookup/match combo with no luck thus far. Not the best with excel… just an fyi.
So I am trying to auto fill a form so I don't have to waste hours doing manual entry.
The data table sheet is MASSIVE and reformatting it is a bit out of the question.
So based on a tool number and part number for a specific tool I was wanting to output the job number and heat treat number that corresponds to each component.
Please Help!!!
In the above image the Job number output would be "7" and the heat treat output would be "8"
I apologize for the initial error
Bookmarks