View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Noncentz303 Noncentz303 is offline
external usenet poster
 
Posts: 14
Default Creating a Pivot Table to reference values

I have an excel sheet that has values that are no longer used. We would like
to convert these values on another sheet but have quite a bit of numbers so a
refence sheet would be awesome. here is an example
NEW OLD(VALUES)

1037 DLB
1040 444
1026 LLL
1010 888, EEE

I would like to be able to convert all the old values such as DLB from my
old spredsheet to 1037 on the new spreadsheet.

A point the right direction would be great....