Posted by zen on June 07, 2001 6:40 AM
I have a problem? it's this, i have a master data sheet with 1000+ names (rows down) with info (columns across). now i can use both vlookup and index/match pretty well. i need a formula that returns the name ("secondname"&" "&"firstname") in a1 if there "startdate" is within this week (b4 everyone piles answers on me, i've done this). Now the problem is in a2 want the next instant of this to be diplayed, and a3, a4 and so on, is there some kind of array or formula that will look at a1 and dicount from the search. i'd prefer a 1 of formula that can go into a2,a3,a4etc. so i don't have to keep writing something different.
sorry if this isn't very well explained but it confusing me.
thanx for n e hlp.