Using a Vlookup with a Hlookup(maybe)

Im having problems trying to create this formula and not really sure how to go about doing it.

Cells B5=B13 are never in the same order in a download I do daily. The C5=G13 are usually the same part, but sometimes they will change. I'm trying to make a template to tell if the part changes I will be able to find out. Sheet1 is a different order than Sheet two and I need to confirm the numbers are the same.Book1.xlsx

So When I download the document, I want to copy the information into the template and have it correspond to a previous document that should be correct. If any number is different it will flag me with a " Value" or something.


So here what I was trying to do. Use a Vlookup for B5=B13 and then a hlookup for C5=G5 for B5.

See attached example, I used conditional formatting to highlight changes, based on using a vlookup/match technique.

NICE!
Thats exactly what I;m looking for

is there a way I can grab the formula from you

Check in the conditional formatting, the formula should be stored in there, for C5 I used:
=NOT(C5=VLOOKUP($A5,$A$17:$G$25,MATCH(C$4,$A$16:$G$16,0),0))

Thanks This will give me a start on it. It looks like Ill have to tinker with it abit.

This wont show the number if the numbers are the same, correct? Also this doesnt link to the first sheet, correcT?




Thanks so much for the help. I've spent a couple hours trying to work on this, but didn't get very far.

This will highlight numbers in the table that are different and leave the other ones the same. In the example I posted I copied both tables to the same sheet so it was easier to see what was going on but you can add sheet references like so:
'Sheet1'!$A$17:$G$25