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