# Find range of cells within table

#### Vshurden

##### New Member
I have data in e3:g3, I want to know if that same range of data is repeated in any row in a3:c150. Is there a formula to do this?

### 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.

#### Rijnsent

##### Well-known Member
Hi Vshurden,

the formula for H3 (assuming you have your check formula there) would be:
=COUNTIFS(A\$3:A\$150,E3,B\$3:B\$150;F3;C\$3:C\$150;G3)
If that formula shows a 1, there is a match somewhere, if it's >1 there are multiple matches, if it's a 0, you have no matches.
Hope that helps,

Koen

#### Rick Rothstein

##### MrExcel MVP
Hi Vshurden,

the formula for H3 (assuming you have your check formula there) would be:
=COUNTIFS(A\$3:A\$150,E3,B\$3:B\$150;F3;C\$3:C\$150;G3)
If that formula shows a 1, there is a match somewhere, if it's >1 there are multiple matches, if it's a 0, you have no matches.
You mixed you delimiters for the function... your first two delimiters are commas but your last three are semi-colons. Assuming commas throughout, your formula would be...

=COUNTIFS(A\$3:A\$150,E3,B\$3:B\$150,F3,C\$3:C\$150,G3)

#### Rijnsent

##### Well-known Member
Hi Rick,
good one, my settings are semi-colons and I generally try to change them to commas when posting here (as it seems the default), but did a sloppy job this time (manual labor, will use search&replace next time),
Thanks for pointing it out,
Koen

Replies
11
Views
229
Replies
28
Views
468
Replies
16
Views
105
Replies
2
Views
75
Replies
1
Views
60

1,127,898
Messages
5,627,530
Members
416,250
Latest member
darius_rebelo

### 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