Hey all,

I have some experience with (slightly) more complex than SUMMING B1+B2 etc... However, I am a bit stuck with a more complex formula (to be used across 2 sheets) - I have a feeling I might need to use the LOOKUP function or possible MATCH, but I have no idea how to incorporate either into an IF function. Sorry, I hope this isn't starting to sound too confusing :/

This is the situation I have:
2 sheets in a workbook.

First sheet contains a full list of all available products:
  • Column 1 - Product ID
  • Column 2 - Unit Price

Second sheet contains on overview of our purchases in the month.
  • Column 1 - Product ID
  • Column 2 - Price Paid

I am looking to have my formula take the product ID on sheet 2 and find it on sheet 1, then, once it's 'matched' a line, to check the price corresponds. Is that impossible?

And either to have some conditional formatting in there to highlight those that have a discrepancy.

When writing my own formula, I came unstuck when I found myself writing an IF statement inside another one and I'm fairly certain Excel would give me a sideways look if I plugged that in the formula bar, so any help here would be great!

Thank you