Identification using multiple criteria

[CarGuy240]

Hi there,
I would like to help out some of our sorting guys at our company. We receive parts with barcodes and sometimes without. They are car parts from junkyards. I want to make the sorting process better since things get incorrectly identified and I end up re sorting them. I bought a barcode scanner for them.
I am trying to set up a database for them where all they have to do is scan 2 possible barcodes to get the product identified. I am trying to make a function that will accept one or both of the input scan and will be able to id them. (the labels are uniquely paired for the majority)

I'll insert what I did so far with lookup and Vlookup. I tried to keep the data on a separate sheet but it wasn't working out for me so I put it on the same sheet way under the functions. That worked 75% of the time but then I ran into issues with using only one of the barcodes and it wasn't able to id them.

 

[CarGuy240]

I cant attach the images directly from my computer so I will host them. I guess I'll put the stuff here for now.

the important stuff starts at Row 5.
A4 is Part number (just a title)
A5 is =VLOOKUP($C$5&$D$5,C40:G73,4,FALSE)

B4 is application (what car it came off of - title )
B5 is =VLOOKUP($C$5&$D$5,C40:G73,5,FALSE)

C4 is Motor Label scan (just title)
C6 is where the workers scan it and it gives a long barcode.
C5 is a left(c6,3) since we only need the first 3 digits

D4 is Module/ECU scan (title)
D6 is the full barcode scan
D5 is the left D6,2 function

E4 is the Module part number (title)
E5 is =VLOOKUP($C$5 & $D$5,C40:G73,2,FALSE)

F4 is Module program code (title)
F5 is =VLOOKUP($C$5&$D$5,C40:G73,3,FALSE)


So my data is under this function starting at Row 40.
A39 is the motor scan data (the 3 digit codes that come up shortened in C5
B39 is the Module scan data (the 2 digit codes that come up shortened in D5
c39 is the helper column that combines A39&B39 together
D39 is the module part number data
E39 is the module program code listing
F39 is the part number
G39 is the application (what car it fits)

I'm just learning a lot about excel. I found out about the lookup function yesterday. So I'm still researching stuff about the any and choose function. I think its just a combo of some function I don't know about yet. I'm not just sitting here waiting to be spoonfed or given a fully functioning sheet. I just would appreciate some guidance on where to go.

Thank you so much for reading and taking the time to help this noobie!

 

[CarGuy240]

https://lensdump.com/i/8LMk65


https://lensdump.com/i/8LMThC

 

[CarGuy240]

Bump

Any of you have suggestions on what I should be looking for?