Hello i have a problem with choosing Rows, And Columns automaticcally.
PROBLEM:
Priority listing data pic.png
I am interested in the priority in the bottom sheet being layed out automatically, and accoring to what priority is where (bottomsheet)
The Data should be placed correctly
Thanks in advancePriority, listing data.xlsx
Last edited by Kartoffelmos; 05-26-2013 at 10:14 AM.
Put this formula in B10, then copy the cell down and across the lower table:
=INDEX(B$2:B$6, MATCH($A10, $E$2:$E$6, 0))&""
_________________
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!)
Thank you alot, Works like a charm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks