I've searched through the past posts and can't figure this one out. By the information in the posts this one should be easy for this board.
What I'm trying to do:
I'm comparing one inventory spreadsheet with another and want to return either 'dead' or 'exception'.
On Sheet 1 I need to look up the location in column A and the part number in column B if there is a match on Sheet 2 return 'exception' and if not return 'dead'
Example data:
Location Part Number Exception?
65214 13220112 Formula Here
55412 78884221
12445 33654156
Thanks in advance for the help.
What I'm trying to do:
I'm comparing one inventory spreadsheet with another and want to return either 'dead' or 'exception'.
On Sheet 1 I need to look up the location in column A and the part number in column B if there is a match on Sheet 2 return 'exception' and if not return 'dead'
Example data:
Location Part Number Exception?
65214 13220112 Formula Here
55412 78884221
12445 33654156
Thanks in advance for the help.