wild cards?
 

I have a spreadsheet with an imported list of employee numbers . The problem
is there are letters attached to the employee numbers signifying the
particular job the employee completed.
A C
PF44250 Bill Smith
BA85460 John Doe
AB87654 Jim Moore

I was wondering if there are wild cards that I can build into a formula that
will allow me to ignore the letters . I could use Vlookup to produce the
employees name which is what I need in column C.

Thank you in advance for any help you can provide

wild cards?
 

Try one of these:

D1 = 87654

=INDEX(B1:B3,MATCH("*"&D1,A1:A3,0))

=VLOOKUP("*"&D1,A1:B3,2,0)

Biff

"ferde" wrote in message
...
I have a spreadsheet with an imported list of employee numbers . The
problem
is there are letters attached to the employee numbers signifying the
particular job the employee completed.
A C
PF44250 Bill Smith
BA85460 John Doe
AB87654 Jim Moore

I was wondering if there are wild cards that I can build into a formula
that
will allow me to ignore the letters . I could use Vlookup to produce the
employees name which is what I need in column C.

Thank you in advance for any help you can provide

wild cards?
 

Works Perfect!! Thank you so much for the quick reply

"T. Valko" wrote:

Try one of these:

D1 = 87654

=INDEX(B1:B3,MATCH("*"&D1,A1:A3,0))

=VLOOKUP("*"&D1,A1:B3,2,0)

Biff

"ferde" wrote in message
...
I have a spreadsheet with an imported list of employee numbers . The
problem
is there are letters attached to the employee numbers signifying the
particular job the employee completed.
A C
PF44250 Bill Smith
BA85460 John Doe
AB87654 Jim Moore

I was wondering if there are wild cards that I can build into a formula
that
will allow me to ignore the letters . I could use Vlookup to produce the
employees name which is what I need in column C.

Thank you in advance for any help you can provide

wild cards?
 

You're welcome. Thanks for the feedback!

Biff

"ferde" wrote in message
...
Works Perfect!! Thank you so much for the quick reply

"T. Valko" wrote:

Try one of these:

D1 = 87654

=INDEX(B1:B3,MATCH("*"&D1,A1:A3,0))

=VLOOKUP("*"&D1,A1:B3,2,0)

Biff

"ferde" wrote in message
...
I have a spreadsheet with an imported list of employee numbers . The
problem
is there are letters attached to the employee numbers signifying the
particular job the employee completed.
A C
PF44250 Bill Smith
BA85460 John Doe
AB87654 Jim Moore

I was wondering if there are wild cards that I can build into a formula
that
will allow me to ignore the letters . I could use Vlookup to produce
the
employees name which is what I need in column C.

Thank you in advance for any help you can provide