# Issue with MATCH

#### shakeregg

##### New Member
Hey all,

FormR kindly helped with combining two formulas together:

=IF(AND(INDEX(T:T,MATCH(E5,AF:\$AF,0))=G5,INDEX(BJ:BJ,MATCH(E5,AF:\$AF,0))=H5),"Yes","No")

This formula is replicated in Rows until 1500 i.e.

=IF(AND(INDEX(T:T,MATCH(E6,AF:\$AF,0))=G6,INDEX(BJ:BJ,MATCH(E6,AF:\$AF,0))=H6),"Yes","No")

etc etc

The issue that I'm now facing is that on occasions the data inputted in Column E and AF may be the same in multiple cells i.e. Smith, John. As a result it's often incorrectly returning a 'No' as it's picking up the first Smith, John in AF. What I want it do if possible is to continue searching for the exact match (T:T & G5, BJ:BJ & H5 etc) and return a 'No' then if it's not found.

Hopefully that makes sense

Cheers for any help people can provide!

Matt

### Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

#### oldbrewer

##### Well-known Member
are you certain there are 0 or 1 perfect matches ?

#### oldbrewer

##### Well-known Member
 row 4 bob smith 9 bob jones 14 row 5 tom jones 7 b jones 5 rob jones 12 bob jones 14 14 obtained by bill green 16 =OFFSET(\$A\$4,MATCH(E5,\$A\$5:\$A\$100,0),1)

<colgroup><col width="64" span="11" style="width:48pt"> </colgroup><tbody>
</tbody>

#### DanteAmor

##### Well-known Member
Use this:

Excel Workbook
AEFGHTAFBJ
1
5John SmithYesnewoldwithoutJohn Smithnew
6CarolNoSwitchwhitewithoutJohn Smithnew
7SueYesislabonitanewJohn Smithold
8SwitchCarolYellow
9SwitchCarolPink
10SwitchCarolblue
11islaSuecan
12islaSuebonita
13islaSuedessert
sheet1

Last edited:

##### MrExcel MVP
[…]

[…]

Try to provide a small sample along with the desired output.

Replies
1
Views
84
Replies
2
Views
754
Replies
0
Views
167
Replies
1
Views
205
Replies
8
Views
401

1,195,591
Messages
6,010,614
Members
441,558
Latest member
lambierules

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