I am trying to compare prices on 2 seperate worksheets. Here is the Criteria:

1) First it needs to look at the Item# (B) column in the Report Tab
2) Then it needs to find that number (D) in the Price List Tab
3) then it needs to look at the Whse column (I) in the Report tab and Depending on the warehouse it will pick which column to compare the price to in the price list (I:K)
4) If it is (NJ01 will be East Coast (I)), (FLs01 and MAE2 will be central (J)), (CAs82 will be West Coast(K)) There are more Warehouses for each column this is just a sample
5) Then it needs to Highlight the Price Column in the Report tab if it is less then the Price in the Price List Depending on the column it chose
**These two tabs will actually be in seperate workbooks - Just did it this way to simplify things.


Here is a sample workbook: