Finding data in one column that exists in another and it's cell location

**keithshapiro** · 12-09-2011, 01:55 PM

I searched but couldn't find what I was looking for so my apologies if it's already on this forum somewhere.

I typically use this: =iferror( vlookup(A1 , B:B , 1, 0) , "Not Found")

and it tells me if something is in 2 columns however I can't figure out how to have it display where in the B column it's located so I can deal with that data. Can someone help me with this?

Thanks
Keith

**Haseeb Avarakkan** · 12-09-2011, 02:23 PM

Use MATCH function,

=MATCH(A1,B:B,0)

This will show you in which row A1 located in Col_B. If not found will show a #N/A error. To avoid errors use IFERROR.

=IFERROR(MATCH(A1,B:B,0),"Not Found")

**keithshapiro** · 12-09-2011, 02:49 PM

Thank you so much! This site is so helpful for those of us that don't use Excel as extensively and have little resources to find answers! I love it!

Thanks again

Keith