cell location containing specific text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i need to find specific text on a sheet and return the cell location of the
found text... how do i do that?
 
Gregg

=ADDRESS(MATCH("goombah",B:B),1)


Gord Dibben MS Excel MVP
 
Haven't even thought about that word (spelling doesn't count) since I was
growing up in N.Y. in the 50's.<vbg>

--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
Gregg

=ADDRESS(MATCH("goombah",B:B),1)


Gord Dibben MS Excel MVP
 
RD

It's a "goodfellas" term.

Is that where you became a "made man"<g>


Gord
 
I know exactly what it is!<g>

Grew up on the "Lower East Side", next to "Little Italy", in what I believe
they now call SoHo (*nothing* like London's).
My old neighborhood is now the VILLAGE EAST.

Believe me, those motion pictures are pretty accurate!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
Gord Dibben said:
RD

It's a "goodfellas" term.

Is that where you became a "made man"<g>


Gord
 
SoHo in New York City means South of Houston (as in Houston Street).
It is somewhat to the north of Little Italy and to the north and west
of the Lower East Side.

The East Village is north of both SoHo, the Lower East Side, and
Little Italy...

Dave

I know exactly what it is!<g>

Grew up on the "Lower East Side", next to "Little Italy", in what I believe
they now call SoHo (*nothing* like London's).
My old neighborhood is now the VILLAGE EAST.

Believe me, those motion pictures are pretty accurate!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------"Gord Dibben" <gorddibbATshawDOTca> wrote in message



 
Not really a forum to discuss municipal geography, but I was born and bred
on Manhattan Island(referred to as New York City), on 6th Street, between
1st and 2nd Avenues.

Go back there every year to visit family and do some hunting on some upstate
property.

So I can attest to the slight discrepancies in your location descriptions.
Sounds like you maybe got them out of a book, or Google!<bg>
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------



SoHo in New York City means South of Houston (as in Houston Street).
It is somewhat to the north of Little Italy and to the north and west
of the Lower East Side.

The East Village is north of both SoHo, the Lower East Side, and
Little Italy...

Dave

I know exactly what it is!<g>

Grew up on the "Lower East Side", next to "Little Italy", in what I
believe
they now call SoHo (*nothing* like London's).
My old neighborhood is now the VILLAGE EAST.

Believe me, those motion pictures are pretty accurate!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------"Gord
Dibben" <gorddibbATshawDOTca> wrote in message



 
I've lived in Manhattan for 31 years and so know its layout well.

Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top