VLOOKUP - Help wanted

F

Finance Guru

Hello,

I am running excel 2003. Can somebody please help.

I have 2 columns
Row A B
1 1525-FE-Clientname FE
2 2799-HE-Clientname HE
3
4


Colum A data is selected from a dropdown list.( of which there are about 300
items in the list ) I would like to have a Lookup Function that checks out
the 6+7 character of the column A entry and put the result into Colum B.
Presently I have to type in the data into column B based on the result of the
entry in Column A.

Any assistance would be appreciated.
 
K

krcowen

try =mid(a1,6,2) and copy it down as many rows as you need.

Good luck

Ken
Norfolk, Va
 
G

Gord Dibben

Assuming all are same format. You did say "6+7"

=MID(A1,6,2) in B1 and copied down.


Gord Dibben MS Excel MVP
 
F

Finance Guru

Thank you all for your answers. You all seem to have come up with the same
answers,so I will try it tomorrow.

Can some just explain the syntax ( laymans speak ) behind your formula. Why
? Because I am quick learner,and I am sure that in my w/sheets I can use
this over again.
 
F

Finance Guru

Thank you very much for your response. Just as a note every time I see
'Garry"s Student,it cracks me up - what an absolutely fabulous pen name.
 
G

Gord Dibben

MID is a worksheet function for finding characters within a string.. See help
also on RIGHT and LEFT functions.

6 is the first character to start extracting at, 2 tells Excel how many
characters to extract.


Gord
 
F

Finance Guru

Gord,
Many thanks for the formula answer and the explanation.
Greatly appreciated
FG
 
Top