wild cards?

F

ferde

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
 
T

T. Valko

Try one of these:

D1 = 87654

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

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

Biff
 

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

Similar Threads

Vlookup function... 4
VLOOKUP function part 2... 5
Macro that splits content from cell if given character is found 3
EXCEL Wild Cards 2
Wild Cards 4
VLOOKUP & IF used with > or < 7
Help!!! Need formula for boss 3
VLookup: Can formula use value loaded from a drop down list? 4

Top