Excel - Index Match Function

xirokx · 20 Jul 2018 at 15:49

Hey there

I am trying to work out how I can use the INDEX MATCH function in Excel to tell me if a value in one column exists in another column.....any help would be appreciated , see below example:

Col1 Col2 Does it exist
1 2
2 3
3 4

So in the "Does it exist" column the first two rows will have a Y displayed inside it and the last row will have a N displayed inside it...

Any help would be appreciated

thank you

bremen1874 · 20 Jul 2018 at 18:45

Any specific reason you want to use INDEX MATCH?

What you want can easily be achieved using VLOOKUP.

xirokx · 21 Jul 2018 at 22:17

INDEX MATCH is more accurate....

The data in the example I have provided is very minimal I need to do this for thousands of rows.

Thanks

bremen1874 · 21 Jul 2018 at 22:36

More accurate in what way?

=IF(ISERROR(MATCH(B1,A:A,0)),"N","Y") gives the same result.

DeanT77 · 21 Jul 2018 at 22:39

vlookup is as accurate as index/match