Help with Lookup and Match Functions

[Dee1]

I have a database prg. from which reports are export to Excel. But there
is a particular report that shows code instead of actual headings. Let
me give example:

Database Reoprt:

Depots f11001 f11010 f11015 f11049
Onitsh-dep-stock 0 0 3 27
Enug-wh1-stock 0 0 0 0
Owerri-dep-stock 0 0 0 31
P.harc-dep-stock 0 0 2 29

My Normal Report Template

S/N Depots RKSF STM Cnct RSM
1 Onitsh-dep-stock 0 0 3 27
2 Enug-wh1-stock 0 0 0 0
3 Owerri-dep-stock 0 0 0 31
4 P.harc-dep-stock 0 0 2 29

The codes and actual items:

f11001 RKSF
f11010 STM
f11015 Cnct
f11049 RSM

I need a link to automate the link between the two files so I wont have
to enter/replace the codes each time I run the report.

I attached a sample excel file

Thanks in anticipation of your help.

Attachment filename: sample.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=464966

 

[Frank Kabel]

Hi
one way would be using an additional row as header (with the corrected
names). Lets say you insert a new row 1 then enter the following in B1
=VLOOKUP(B2,'code_sheet'!$A$1:$B$10,2,0)
and copy this to the left
You may hide row two (with the code entries)