I have a list of data with two columns, A=Day of the week, B=Persons Name. There are multiple instances of the day. I am trying to create a VLOOKUP on a new sheet that returns the first value initially, but then the next value as the formula is copied down. So if there are three people listed on Tuesday, the first three formulas on the new sheet would be the three people, not the first person three times.
Last edited by mt5; 08-03-2010 at 02:37 PM.
Here's a way using an array formula. The formula entered in G1 is an array, it must be confirmed by pressing CTRL-SHFT-ENTER, then it can be copied downward.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
AWESOME!!!
I appreciate your fast and accurate response. I have learned quite a bit from this website. I made a coulpe small changes to what you had increasing the refrence range for my project. Posting it back for others if needed.
Thanks again, you saved me a ton of brain cells.
mt5
This helped me SO much too!
As you can see, I was trying to find this answer since yesterday morning!
http://www.excelforum.com/excel-prog...le-values.html
Thanks a bunch JBeaucaire!!
I hate to throw my noob hat into the ring, but I have a question: why, when you insert a row into either of your worksheets posted here, does the formula slowly cease to function? It seems like the pertinent values in the formula update to reflect the inserted row, but the values slowly fall off as more and more rows are added. I have been trying to figure this out, but I'm a rank amateur.
griffinxi,
Welcome to the Forum, unfortunately:
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks