Prev: Vlookup & relative cell reference?
Next: Sumproduct with sumif over mutiple worksheets
From: patrick barbour on 15 Apr 2010 13:55
Thanks for the input Steve. I'll be able to try your idea later today and will report back. -)

---
frmsrcurl: http://msgroups.net/microsoft.public.excel.worksheet.functions/Use-Vlookup-to-store-formulas
From: patbarb on 16 Apr 2010 17:20
Well, I don't think that the Index/Match/Offset stuff above gets me where I want to go - but that was cool learning that Offset can create a vector on the fly for Match to use! (That is, take an existing array and reshape it to only be 1 column wide, like above, which is what Match wants.) I'll try another post and do a better job explaining. Thanks all! --patrick

---
frmsrcurl: http://msgroups.net/microsoft.public.excel.worksheet.functions/Use-Vlookup-to-store-formulas
First  |  Prev  | 
Pages: 1 2
Prev: Vlookup & relative cell reference?
Next: Sumproduct with sumif over mutiple worksheets