Need help with indexing complete data sets for each entered value.
Please see example to better understand what I am trying to do.
I am lost. I have been trying for weeks.
Thank you.
Steve
INDEX.xlsx
Need help with indexing complete data sets for each entered value.
Please see example to better understand what I am trying to do.
I am lost. I have been trying for weeks.
Thank you.
Steve
INDEX.xlsx
Pete_UK...you are a master of excel. If you can have a look at what I need...it would really be appreciated.
It's not at all clear to me what you're trying to do. Maybe this:
Select ALZ3:ALZ22. In the formula bar, paste
=INDEX($A$3:$ALL$22, 0, MATCH(ALZ1, $A$1:$ALL$1, 0))
Press and hold the Ctrl and Shift keys, then press Enter.
Copy right.
Entia non sunt multiplicanda sine necessitate
Lets assume that there is no data in the colored boxes and I enter 107 in to D1...the yellow set and I would need the complete set for 017 071 107 170 701 710 to come up in the Yellow. You follow? Thank you for your reply and I will try what you said.
Thank you.
No, I don't, sorry. I don't understand the significance of the colors, what cells are for data entry, what cells are calculated results, and what the results should be based on the data entry.You follow?
That just made a bunch of 0's and I can't even close excel...thanks for trying to help.Index photo.PNG
The first value would be entered in to D1 which in this case is 107....I don't need to calculate anything....just indexing the data sets for 017 071 107 170 701 710. Photo 2.PNG
The colors are just to break up the sets for the 6 values entered....no it would be understood better.
Lets assume that there are no values in D1 thru D6...and I want the sets for 107 to come up in the Yellow...instead of scrolling to the left to locate the sets for 107...I would like to enter 107 in to D1 and have the sets for 107 to come up in to the Yellow....I really can not explain any more. Thank you for your help.
If UK Pete can't help...no one can.
My name is not Pete, but I made something for you in just the yellow cells.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Why not?Can I get it to work for the other colors?
Cut (AMA38:AMA45)
(AMF38:AMF45) paste
Copy (ALZ1:AME1)
(AMF 1:AMK1) Paste Special; Formulas
Cut (AMF38:AMF45)
(AMA38:AMA45) Paste
Last edited by popipipo; 11-02-2013 at 07:01 PM.
Look at reply #15
I changed my answer
Something isn't right. When I key in 114...the sets for 144/414/441 come up.114.PNG
And when I key in 744...the sets for 477 come up....something is not working 744.PNG
When I key in 556 ....the sets for 566 come up......556.PNG
try this one
It works great for the first set but not the others....how would one replicate it for the other five values?
Thanks again Popipipo.Photo 254.PNG
As I told you in #15how would one replicate it for the other five values?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks