I have come up with a series of nested formulas that result in the starting cell that I need. How do I now combine that cell with the range ending cell in the formula for the vlookup?
How do I create this: NestedFormulaResult:B99? <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi Dennis, > You can do that using the match function in an indirect address. For the > first holiday, you use the match to create the address for the holiday. > For the second, you use the first match to set the start row for a > vlookup. If you want to try for three, then the second needs to be a match > as well and that function gets used in the third search. > tc > >> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
