# match each row

##### New Member
 different value same value to match result in one cell 05/Oct/2021 29/Apr/2022 text 29/Sep/2021 28/Sep/2021 text1 10/Oct/2021 05/Oct/2021 text2 29/Apr/2022 29/Mar/2022 text3 13/Oct/2021 11/Oct/2021 15/Dec/2021 23/Aug/2022

How to match each row from `different value` with the date from 'same value to match'. If there is a match then in one cell to result text from column 3 'result in one cell'.
For eg. from column 1 date 05/oct/2021 and 29/apr/2022 match with column 2 'same value to match' and the result should be: 'text, text3'. I tried with index and match but show only the first result. Thanks.

Last edited by a moderator:

### Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Sorry for the previous post with the data.. I attached a screenshot.

#### Attachments

• attached.png
5.8 KB · Views: 5
I tried with this formula
={index(E18:E21,match(C18,D18:D21,0)),index(E18:E21,match(C19,D18:D21,0)),index(E18:E21,match(C20,D18:D21,0)),index(E18:E21,match(C21,D18:D21,0))}

RESULT IS text2 #N/A #N/A text

How to eliminate #N/A from the array? to remain only with text2 and text?

Any better solution?

#### Attachments

• Screenshot 2022-01-09 231707.png
19.5 KB · Views: 4

Replies
14
Views
1K
Replies
3
Views
293
Replies
5
Views
262
Replies
4
Views
321
Replies
5
Views
222

1,207,423
Messages
6,078,441
Members
446,338
Latest member
AliB

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