named range - column of a given value

[HarryKlein]

Hi,
I have a name range, let's call it myrange.
I would like to know, if a string exists in myrange, and if yes, I also would like to get its row and column value - the ones I use for reference with RefersToRange.
Is there a simple way of it?
Thank you

[mohadin]

Hi
Maybe

Please Login or Register  to view this content.

[Mrrrr]

I think INDEX-MATCH combined with CELL function can do what you want:

Please Login or Register  to view this content.

Make sure you change ; with , if required according to your regional settings.

Simplest way is usually without VBA imo.

[BMV]

@Mrrrr myrange can be 2d array.

[HarryKlein]

thanks a lot

[HarryKlein]

that's correct