Match records in 3 columns

**alexemberey** · 05-14-2013, 06:27 PM

Hi guys - newbie here, incredibly grateful for any/all help.

Columns F, T and S of the attached worksheet contain order IDs.

Each order ID could be present in 1, 2 or even all 3 columns.

How could I find out and show which columns each order ID is present in?

Thanks so much in advance for your help!

A

**tigeravatar** · 05-14-2013, 06:42 PM

alexemberey,

Welcome to the forum!
Attached is a modified version of your posted workbook.
I used Advanced Filter to get a unique list of all of the Order ID's.
Then in cell F2 and copied over and down is this formula:

=IF(COUNTIF(A:A,$E3)>0,"X","")

Does that work for you?

**oeldere** · 05-14-2013, 06:58 PM

with index / match

if the data is found in the column it shows the value.

otherwise it shows #N/A (there is no data found in that column)

see the attached file