# Comparative formula

#### Pizzio

##### Active Member
Referencing CAT in Sheet 1; IF CAT in Sheet 2 and 3 are a match to column B then "match", if not "review"

Sheet 1, cell A1 = CAT
Sheet 2, cell A200 = CAT, B200 = 50
Sheet 3, cell A1900 = CAT, B1900 = 50

### Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
Hello,

have assumed you only have one instance of CAT in sheets 2 and 3.

=IF(VLOOKUP(A1,Sheet2!A:B,2,0)=VLOOKUP(A1,Sheet3!A:B,2,0),"match","review")

Replies
1
Views
160
Replies
2
Views
137
Replies
8
Views
243
Replies
6
Views
204
Replies
6
Views
207

1,207,089
Messages
6,076,517
Members
446,211
Latest member
b306750

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back