Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am trying to do something that seems simple, but not sure how to do it...
I want to have a table of text where the first column is a category and the adjacent cells in each row are the values for that category that users might want to find. The user types in a value, the function checks which category it is in and returns that value. Here is sample data; first value in row is category, other values are possible user entries writing device pencil pen marker sharpie paper scrap paper notepad post it index card fastener tacks staples paper clips tape The way I want it to work, if a user types in 'pen', it returns the value 'writing device' Any help appreciated. I have searched here and see some examples with INDEX and MATCH, but none seem to be doing this. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Display an array of references | Excel Worksheet Functions | |||
how to find all matches in an array | Excel Discussion (Misc queries) | |||
How do I find a value in an array (VLOOKUP? HLOOKUP?) | New Users to Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |