| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Match() function
I understand that with a match type of 0, excel finds the first value that is
exactly equal to the lookup value. I need to match the exact value too, but I would like it to find the LAST value in my range (which is a row). |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with Match() function
can't be done with the MATCH function but this array function will do what
you want. Just replace "B" with whatever you are looking for. {=MAX(COLUMN(A1:F1)*(A1:F1="B"))} enter it without the quotes and then press ctrl+shift+enter. "MandMsRED3" wrote: I understand that with a match type of 0, excel finds the first value that is exactly equal to the lookup value. I need to match the exact value too, but I would like it to find the LAST value in my range (which is a row). |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with Match() function
I'm sorry. I meant enter it without the brackets. After you press
ctrl+shift+enter it will add them for you. "Sloth" wrote: can't be done with the MATCH function but this array function will do what you want. Just replace "B" with whatever you are looking for. {=MAX(COLUMN(A1:F1)*(A1:F1="B"))} enter it without the quotes and then press ctrl+shift+enter. "MandMsRED3" wrote: I understand that with a match type of 0, excel finds the first value that is exactly equal to the lookup value. I need to match the exact value too, but I would like it to find the LAST value in my range (which is a row). |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MATCH function, exclusion question | Excel Discussion (Misc queries) | |||
| rounding numbers for match function | Excel Worksheet Functions | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| I want to use the MATCH function with the AVERAGE function but I . | Excel Worksheet Functions | |||
| Match function selecting first value it matches on exactly | Excel Worksheet Functions | |||
Linear Mode
