excel - pick fm drop-down list + automatically hv category in nxt cell

[emerald]

Hi

I have created a drop-down list in a column in an excel spreadsheet.

There are several CATEGORIES for the ITEMS in the drop-down list column.

The ITEMS are
e.g. ORANGES, BANANAS, APPLES, CARROTS, BEEF, LEEKS

In the adjoining column to the left I manually enter the CATEGORIES
e.g. FRUIT, VEGETABLE OR MEAT

Is there a way of setting up a condition so that if I enter
for example ORANGE in the drop-down list column, that the word FRUIT can be automatically placed in the adjacent CATEGORY column?

Appreciation for any help, clarification or maybe a reality check for me that Excel does many things but not neccesarily what I want. Right now I'd like a cup of tea. I know... Excel does NOT make tea!

tks
Emerald

"Be kind for everyone
you meet is fighting
a harder battle

 

[SkipVought]

Hi,

This is a simple LOOKUP.

Assuming that your TABLE is in Sheet2, headings in A1...
[tt]
B2: =vlookup(a2,sheet2!A2:B99,2,false)
[/tt]


Skip,
[sub]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]

 

[emerald]

Hi SkipVought

Thanks for yr reply.

OK so
the table is in Sheet2
headings A1, B1... are also in Sheet2

According to yr instructions,

pls can u explain which sheet your reference B2 is on?

and also exactly where do I put
=vlookup(a2,sheet2!A2:B99,2,false)

and if it is not too complicated,
what is the significance of

A2:B99
,2
and
,false

Appreciations
E.


"Be kind for everyone
you meet is fighting
a harder battle

 

[SkipVought]

"and if it is not too complicated,
what is the significance of

A2:B99
,2
and
,false
"

Did you check HELP?

"headings A1, B1... are also in Sheet2"
"pls can u explain which sheet your reference B2 is on?}

B2 is right under B1. B2 is where the formula is entered.

Skip,
[sub]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]

 

[emerald]

Hi Skip

Tks v much for yr help

I took yr advice and tips and have sorted it out.

Emerald

"Be kind for everyone
you meet is fighting
a harder battle