Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help debugging a VLOOKUP and MATCH combo
I'm experiencing a programmer's nightmare...
I have a function that sometimes works, and sometimes NOT. I'd rather it work or not 100%. If anyone is willing to look at my worksheets, please respond via e-mail and I'll send them to you. It's just 2 pages, with no macros. It deals with VLOOKUP and MATCH function combo, as described in this arthicle. I follow the example exactly, and I even prototyped it with simple data that worked. http://www.microsoft.com/technet/arc....mspx?mfr=true -- - Zilla (Remove XSPAM) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help debugging a VLOOKUP and MATCH combo
You can send the file to me and I'll take a look.
xl can help at comcast period net Remove "can" and change the obvious. Point out what is working and what is not. Biff "Zilla" wrote in message ... I'm experiencing a programmer's nightmare... I have a function that sometimes works, and sometimes NOT. I'd rather it work or not 100%. If anyone is willing to look at my worksheets, please respond via e-mail and I'll send them to you. It's just 2 pages, with no macros. It deals with VLOOKUP and MATCH function combo, as described in this arthicle. I follow the example exactly, and I even prototyped it with simple data that worked. http://www.microsoft.com/technet/arc....mspx?mfr=true -- - Zilla (Remove XSPAM) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help debugging a VLOOKUP and MATCH combo
The problem was that the range_lookup argument was omitted thereby
defaulting to 1 or TRUE and the lookup table was not sorted ascending. Set the range_lookup value to 0 (FALSE) and it worked just fine. Biff "T. Valko" wrote in message ... You can send the file to me and I'll take a look. xl can help at comcast period net Remove "can" and change the obvious. Point out what is working and what is not. Biff "Zilla" wrote in message ... I'm experiencing a programmer's nightmare... I have a function that sometimes works, and sometimes NOT. I'd rather it work or not 100%. If anyone is willing to look at my worksheets, please respond via e-mail and I'll send them to you. It's just 2 pages, with no macros. It deals with VLOOKUP and MATCH function combo, as described in this arthicle. I follow the example exactly, and I even prototyped it with simple data that worked. http://www.microsoft.com/technet/arc....mspx?mfr=true -- - Zilla (Remove XSPAM) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can Index/Match pull lookup_value from a combo box? | Excel Discussion (Misc queries) | |||
Need some debugging help, please | Excel Discussion (Misc queries) | |||
how to get zeros to match in line-bar combo chart on 2 axes | Charts and Charting in Excel | |||
Excel VBA debugging help needed! | Excel Discussion (Misc queries) | |||
Startup Error debugging help | Excel Discussion (Misc queries) |