Hi Dennis,
I don't think that you can use indirect addressing to define the vlookup
range. I have done what you're trying to accomplish, but I don't
remember how or what it was for. If I can dig that information out of
some dark corner of my brain, I'll pass it on to you.
tc
Dennis Marks wrote:
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]
