Hello Everyone, I would like to ask you if i...

[Sabry_G]

Hello Everyone,

I would like to ask you if it would be possible to do the following: - if in COLUMN A I have a list of items, it can be banana, apple, coca cola, fanta is there any way where in COLUMN B authomatically record the type of the item (ie. fruit, drinks accordingly to the content cell in column A)?

I am not sure if this can only be a dream but I would appreciate your support.

THANKS A LOT!

Sabry

[pravse]

sure. give column B an App Formula. Here is a simple one: IF (

IN([Column A], {“banana”, “apple”}),

“Fruit” ,

“Drink” )

[Stefan_Ottoman1]

@praveen very helpful. Have wanted to do this for a while. But what if column A has say, 100 different items and column B say 10 different categories. For

example fish Species (column A) and their families (column B).

Any suggested approach?

[Aleksi_Alkio]

Then you would need to have separate table and you can read correct value from there. It would be like a dependent value.

[Stefan_Ottoman1]

I suspected as much. Thanks again