See attached sample.
Column G1 - I place a number referring to either Column A, B, C or D lists.
As your see all numbers work in G and appropriate list appears until you get to the number "2".
Don't know why? What did I fail to do? What is the quark?
Last edited by khank; 03-24-2011 at 03:07 PM.
Because the headers are not listed in ascending order from left to right, you need to include the 0 type argument in the MATCH() function in order to get exact match.
=INDEX($A:$D,ROW(),MATCH($G$1,$A$1:$D$1,0))
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Again, thanks for your insight.
It's just amazing when you have the correct coding you get the correct answer...
Please remember to mark your threads as SOLVED once they are solved....
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
Sorry about that.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks