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...store-formulas