try
=MATCH("b*",a:a,0)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Frank Pytel" wrote in message
...
I am trying to return a cell address based on a portion of an alphanumeric
string.

I have a column of values on tab A that lists values like B1, B235, C3,
BR4,
etc. I want to return the address of the first cell containing
=SEARCH("B***",A:A).

Ultimately my goal is to find the search() above in column A on tab B and
use that as a starting point for bringing those values on tab A in to tab
B.
From there I can do a Vlookup() to import the remainder of the columns I
need
by creating a named range.

I know I have done this before, but I can't find the file that I created
this function in. I am not a big fan of VB and would like to avoid this.
Can
anyone help me? I would sincerely appreciate it.

Thank You

Frank Pytel