Excel

[Guest]

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.

 

[Guest]

Well, it depends on how many numbers you're talking about. If it's 1 and 2,
then =IF(A1=1,"Fred","John") works. But if you're talking about dozens of
different numbers, you should ue the VLOOKUP function. See here for info:
http://www.techonthenet.com/excel/formulas/vlookup.php

Post back if you have questions.

Dave

 

[Gord Dibben]

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