Hi!
I am trying to see if Excel is able to populate a cell with a text given that another cell has one of a predetermined list of texts put into it. For example, when "blue" is typed in one cell, the cell next to it will give "sky". I have a few hundred of these combinations (ie: red - apple, yellow - banana, etc) so I would like to avoid a really long IF THAN statement function if I can. Is Excel able to do something like this? Thanks!
Thank you everyone for your swift responses and help!
Last edited by ShiroraTsukari; 04-04-2024 at 01:22 PM.
Yes, Excel can do this. You would put your combinations in a 2-column table somewhere and then you would be able to use a lookup function (VLOOKUP or XLOOKUP) or an INDEX/MATCH combination to extract the appropriate "description" from a given "colour".
Attach a sample Excel workbook, as described in the yellow banner at the top of the screen.
Hope this helps.
Pete
This example uses Sheet1, Col A as your location for populating cells whose term will be searched. Example: Sheet1 / A1 the user will enter the term "blue" (see image 1).
On Sheet2 in Cols A & B are listed the primary term and the matching term for each (see image 2).
This example utilizes a formula that performs a "VLOOKUP" of Sheet2 to return the matching term (see image 2).
Refer to attached example workbook ...
IMAGE 1
Sheet1.jpg
IMAGE 2
Sheet2.jpg
The formula should be pasted into Sheet1 / B1, then copied down Col B as far as necessary for future entries in Col A :
=IF(A1="","",(VLOOKUP(A1,Sheet2!$A$1:$B$3,2,FALSE)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks