Replace a whole column?

[Chapman62083]

I have a sorted list of data in column B, I have assigned a code to each individual data in column A. Then I have the list of data unsorted in column D. Is it possible, through pivot tables or something, to replace the unsorted data in column D with the codes assigned in A? All at once? Currently I am using the Replace function, and I can only do it one at a time. I have 550 different codes. It will take forever.....

[caholmes]

You will probably need to use a vlookup function. If you could post the spreadsheet we can take a look at it for you.

[Chapman62083]

How do I attach to this forum?

[caholmes]

1. Click post reply
2. Click Go Advanced
3. Click Manage Attachments (scroll down)

[Chapman62083]

Here it is. Deatails are in the spreadsheet.

[caholmes]

I had to swap columns A and B. Once that is done, you can use a vlookup to get the desired result (see attached)

[Chapman62083]

Great. thats awesome. Now how do i take those results and paste them to my report. When i try to paste the results, it takes the whole equation and doesnt work in the new spreadsheet.