Home

RE: Modern Excel webinars

%3CLINGO-SUB%20id%3D%22lingo-sub-1120933%22%20slang%3D%22en-US%22%3ERE%3A%20Modern%20Excel%20webinars%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1120933%22%20slang%3D%22en-US%22%3EI%20have%20one%20column%20that%20contains%20apple%2C%20pear%2C%20tomato%2C%20onion.%20from%20that%20column%2C%20I%20want%20to%20populate%20two%20different%20cells%20with%20an%20X.%20The%20first%20cell%20is%20Vegetable%20and%20the%20other%20cell%20is%20Fruit.%20How%20do%20I%20do%20that%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1121977%22%20slang%3D%22en-US%22%3ERE%3A%20Modern%20Excel%20webinars%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1121977%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F527372%22%20target%3D%22_blank%22%3E%40bstew2020%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWell%2C%20since%20Excel%20doesn't%20know%20if%20an%20apple%20is%20a%20fruit%20or%20a%20vegetable%2C%20you%20need%20to%20provide%20a%20table%20where%20Excel%20can%20look%20up%20the%20correct%20definition.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20see%20attached%20file%20where%20the%20table%20on%20the%20left%20is%20filled%20with%20the%20definition%20from%20the%20table%20on%20the%20right%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor
I have one column that contains apple, pear, tomato, onion. from that column, I want to populate two different cells with an X. The first cell is Vegetable and the other cell is Fruit. How do I do that?
1 Reply
Highlighted

Hi @bstew2020 

 

Well, since Excel doesn't know if an apple is a fruit or a vegetable, you need to provide a table where Excel can look up the correct definition.

 

Please see attached file where the table on the left is filled with the definition from the table on the right

Related Conversations
Is there any professional support for my Smart Index?
JUSER-C in Excel on
0 Replies
Sort/filter cells with picture
Drin365 in Excel on
7 Replies
Copying random selection
eiregobra in Excel on
5 Replies
Transposing data for better analysis
gckcmc in Excel on
1 Replies