Easily done for your example.

=LOOKUP(B1,{1,2},{"Fred","John"}) Copy down column B

It is the "etc." that always makes it a little more difficult.

"etc." could be 3 more numbers and names or 123 numbers and names.

With many you should create a Lookup table and use VLOOKUP formulas.

Table in D1:E1

Numbers in column A

In B1 enter =VLOOKUP(A1,Table,2,FALSE)


Gord Dibben MS Excel MVP

On Tue, 27 Feb 2007 09:12:17 -0800, Sapperre
wrote:

I have a report that is being exported from Crystal Reports into Excel; the
report contains two numeric columns.

When the report is run, I would like to convert the numeric columns to words
based on the contents of the cell. i.e. if the cell contains 1, change the 1
to 'Fred', if 2, change the 2 to 'John', etc.

Can anybody please suggest an answer?

Thanks.