Easy Question

**chantage** · 11-30-2006, 04:30 AM

In B colom

GENESIS MIN 1,6 MC , 73/78 , DI
GENESIS TR V HC , 65/70
GENESIS TR V HC , 65/70
PANO PLUS TR V HMC , 65/70
PANO PLUS TR V HMC , 65/70
GENESIS PBX 1,6 , 70 , DI
GENESIS PBX 1,6 , 70 , DI

i want to do if "HMC" in the row right it HMC in C colom ..

**Carim** · 11-30-2006, 04:40 AM

Please Login or Register  to view this content.

HTH
Carim

**chantage** · 11-30-2006, 05:22 AM

I want to change my question
i have some code numbers like
100
200
300
400

i want to do.
if formule see 100 then write HMC
if see 200 then write MC
and its go on.

how can i do it ?

**Bryan Hessey** · 11-30-2006, 05:33 AM

Originally Posted by chantage

I want to change my question
i have some code numbers like
100
200
300
400

i want to do.
if formule see 100 then write HMC
if see 200 then write MC
and its go on.

how can i do it ?

Hi,

If this is a list of more than 5 then a Lookup table will be easiest.

Set up a list of numbers in (Say) Sheet2!A1 onwards
then the corresponding display in the B column.

then

=VLookup(A1,Sheet2!A1:B99,2,False)

will show the desired results etc.

Let me know how you go.
---

**Carim** · 11-30-2006, 05:37 AM

Glad the formula I sent you was the correct answer to an easy question ...

As a rule, in this forum, for the benefit of all, a new question means a new thread ...
Meanwhile ...
Regarding your second question ( which is even easier than the first one )create a table with all possible equivalents, then use VLOOKUP() function ...
press F1 for help and for simple examples ...

HTH
Carim