I have got a list of companys with abbreviated names with our purchase spend
with each company, I also have a master list of what the abbreviated names
full alternative. When I do a report at the end of each month the list comes
out with the abbreviated names but I want the full name. Is there a way to
swap the abbreviated name with the appropriate full name? Maybe using a VB
command. I am a novice at VB though so can anyone tell me exactly what to do
if there is a code.

Example

company amount abreviated full
A 1 A AYY
B 2 B BEE
D 4 C SEE
F 9 D DEE
E EEE
F EFF

company amount
AYY 1
BEE 2
DEE 4
EFF 9

this can be acheived through VLOOKUP function.

You may replace the abreviated with full name using VLOOKUP.

Regards
rajesh

"laandmc" wrote:

I have got a list of companys with abbreviated names with our purchase spend
with each company, I also have a master list of what the abbreviated names
full alternative. When I do a report at the end of each month the list comes
out with the abbreviated names but I want the full name. Is there a way to
swap the abbreviated name with the appropriate full name? Maybe using a VB
command. I am a novice at VB though so can anyone tell me exactly what to do
if there is a code.

Example

company amount abreviated full
A 1 A AYY
B 2 B BEE
D 4 C SEE
F 9 D DEE
E EEE
F EFF

company amount
AYY 1
BEE 2
DEE 4
EFF 9

can you give me an example as i'm struggling?

"rajesh" wrote:

this can be acheived through VLOOKUP function.

You may replace the abreviated with full name using VLOOKUP.

Regards
rajesh

"laandmc" wrote:

I have got a list of companys with abbreviated names with our purchase spend
with each company, I also have a master list of what the abbreviated names
full alternative. When I do a report at the end of each month the list comes
out with the abbreviated names but I want the full name. Is there a way to
swap the abbreviated name with the appropriate full name? Maybe using a VB
command. I am a novice at VB though so can anyone tell me exactly what to do
if there is a code.

Example

company amount abreviated full
A 1 A AYY
B 2 B BEE
D 4 C SEE
F 9 D DEE
E EEE
F EFF

company amount
AYY 1
BEE 2
DEE 4
EFF 9

Hi

Example:

Sheet 1 Contains master data

A AYY
B BEE
D DEE
F EFF

Sheet 2 Contains purchase data

A 1
B 2
D 4
F 9


you may write the following vlookup formula in sheet2 to extract company's
full name:

=VLOOKUP(A1,Sheet1!$A$1:$B$4,2,FALSE)

Regards
rajesh

"laandmc" wrote:

can you give me an example as i'm struggling?

"rajesh" wrote:

this can be acheived through VLOOKUP function.

You may replace the abreviated with full name using VLOOKUP.

Regards
rajesh

"laandmc" wrote:

I have got a list of companys with abbreviated names with our purchase spend
with each company, I also have a master list of what the abbreviated names
full alternative. When I do a report at the end of each month the list comes
out with the abbreviated names but I want the full name. Is there a way to
swap the abbreviated name with the appropriate full name? Maybe using a VB
command. I am a novice at VB though so can anyone tell me exactly what to do
if there is a code.

Example

company amount abreviated full
A 1 A AYY
B 2 B BEE
D 4 C SEE
F 9 D DEE
E EEE
F EFF

company amount
AYY 1
BEE 2
DEE 4
EFF 9