| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match text
i am using 'match' to do a match text and put into a category. However, the match is not an exact match, but rather includes all text up until the next match. For example: exact match of 1000 - populates into an apple category exact match of 2000 - populates into an orange category What it's doing right now is if there is 1050, it puts it in the apple category, when I just want it to be NA. Can someone suggest another function i can use to get an exact match? Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Match text
Do
=MATCH(lookup_value,lookup_table,0) -- __________________________________ HTH Bob "L" wrote in message ... i am using 'match' to do a match text and put into a category. However, the match is not an exact match, but rather includes all text up until the next match. For example: exact match of 1000 - populates into an apple category exact match of 2000 - populates into an orange category What it's doing right now is if there is 1050, it puts it in the apple category, when I just want it to be NA. Can someone suggest another function i can use to get an exact match? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match a text | Excel Worksheet Functions | |||
| Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
| trying to match more than 1 text value in a row to show end value | Excel Worksheet Functions | |||
| How to match two different cells text, if the text is not in the . | Excel Worksheet Functions | |||
| match cell text with text in formula | Excel Worksheet Functions | |||
Linear Mode
