Basically I have 15 different material types, each has its own worksheet. based on the first two numbers in the ID code, I need to take the number that is found in the fourth and fifth places and search the respective sheet for a match. The data in the second column needs to be returned.

The VLOOKUP command works for all of the others but I can't get it to work for this one. I keep getting #N/A with no real explanation as to why. I haven't even tried using an IF() statement yet b/c I can't get the other to work. Any ideas? I posted a sample of the workbook earlier.

Thanks

Shane