Change chart/pivot table numeric labels to associated text labels

Hello,

I have an export from a database that I'm bringing into Excel 2010 of about 30K records. Data points are recorded numerically and I have their associated text "value label" (what it would be called in STATA, for example, not sure what it's called in Excel). I want to create various charts/pivot tables with the data and want the labels to be the text label, not the number.

For example, variable ASSIGNMENT has the following possibilities:

1
2
3
4

Here's what each of those "mean" (I have this in another table):

1 - Sick
2 - Overtime
3 - Court
4 - Present

How do I create a chart or pivot table where the labels are "sick", "overtime", etc., and not "1", "2", "3", "4"?



Thanks for any guidance/solutions!

Yes, I can create a helper column.

What would you suggest for the best lookup configuration?

Amazing. Thank you.

Question: did you use the IFERROR in the event there was a value in the original column that didn't have a text value associated with it in the VLOOKUP? I'm wondering why one can't just have the VLOOKUP.

Cool.

And now that I'm applying it to my spreadsheet, another question: VLOOKUP looks to the left most column in an array. If I have my text values in column A and numbers in column B I either need to switch them (which I can do), or use something besides VLOOKUP. Is there a similar formula where I can tell it which column I want it to "look" for?

Will do. Thanks again for your help!