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