cell B will automatically show a text depending on the text on column A

**Elainefish** · 06-05-2013, 05:41 AM

cell B will automatically show a text depending on the text on column A

for ex:

1 = fruits
2 = vegetables
3 = flower

but my problem is my items are like

1.20 apple
1.31 orange
2.3 pumpkin
3.4 flower

I tried to use the formula trim and use =INDEX($C$2:$C$11;MATCH(B16;$B$2:$B$11;1))
but the table cant be read maybe bec of the trim formula

**SDCh** · 06-05-2013, 05:46 AM

Try this on column B17:

Please Login or Register  to view this content.

Note : if needed add ROUNDDOWN(), like this:

Please Login or Register  to view this content.

**acerrhod** · 06-05-2013, 05:49 AM

modified your formula on b17
=VALUE(TRIM(LEFT(A17,1)))

**acerrhod** · 06-05-2013, 05:51 AM

or modified the column c17
=INDEX($C$2:$C$11,MATCH(VALUE(B18),$B$2:$B$11,1))

**Fotis1991** · 06-05-2013, 05:57 AM

And another way....

In column B

=LEFT(A16)+0

Your INDEX formula slightly modificated..

=INDEX($C$2:$C$11;MATCH(B16;$B$2:$B$11;0))

cell B will automatically show a text depending on the text on column A

LinkBack

Thread Tools

Rate This Thread

Display

cell B will automatically show a text depending on the text on column A

Re: cell B will automatically show a text depending on the text on column A

Re: cell B will automatically show a text depending on the text on column A

Re: cell B will automatically show a text depending on the text on column A

Re: cell B will automatically show a text depending on the text on column A

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions