Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I retrieve Cost from a grid using text drop down lists?
I have the following grid:
A B C D 1 Elim Period Cost 2 0/14 6 ??? 3 4 Period 5 Elim 6 12 24 6 0/7 $4.85 $6.30 $8.00 7 7/7 $4.50 $5.95 $7.60 8 0/14 $3.95 $4.75 $6.60 9 14/14 $3.55 $4.35 $5.80 10 0/30 $2.90 $3.80 $5.15 11 30/30 $2.35 $3.15 $4.15 12 60/60 $0.00 $2.70 $3.50 13 90/90 $0.00 $2.05 $2.40 14 180/180 $0.00 $0.00 $1.60 A2 and B2 are drop down lists allowing selection of Elim and Period choices. They are both formatted as TEXT. I need to return the correct cost in C2 for the column-row selected by Elim and Period. I've read through other posts and it seems INDEX() or VLOOKUP() might be what I need, but I just can't seem to make them work. Thanks in advance for your assistance! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I retrieve Cost from a grid using text drop down lists?
Put this in C2:
=INDEX(B6:D14,MATCH(A2,A6:A14,0),MATCH(B2,B5:D5,0) ) Hope this helps. Pete On Jun 5, 10:09*pm, rkenchel wrote: I have the following grid: * * * * A * * * B * * * C * * * D 1 * * * Elim * *Period *Cost 2 * * * 0/14 * *6 * * * ??? * * 3 * * * * * * * * * * * * * * * 4 * * * * * * * Period 5 * * * Elim * *6 * * * 12 * * *24 6 * * * 0/7 * * $4.85 * $6.30 * $8.00 7 * * * 7/7 * * $4.50 * $5.95 * $7.60 8 * * * 0/14 * *$3.95 * $4.75 * $6.60 9 * * * 14/14 * $3.55 * $4.35 * $5.80 10 * * *0/30 * *$2.90 * $3.80 * $5.15 11 * * *30/30 * $2.35 * $3.15 * $4.15 12 * * *60/60 * $0.00 * $2.70 * $3.50 13 * * *90/90 * $0.00 * $2.05 * $2.40 14 * * *180/180 $0.00 * $0.00 * $1.60 A2 and B2 are drop down lists allowing selection of Elim and Period choices. They are both formatted as TEXT. I need to return the correct cost in C2 for the column-row selected by Elim and Period. I've read through other posts and it seems INDEX() or VLOOKUP() might be what I need, but I just can't seem to make them work. Thanks in advance for your assistance! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I retrieve Cost from a grid using text drop down lists?
Thanks Pete!!
I tried something similar off of another post that was combining the MATCHes into one and I could not make it work. Your solution was right on! Rog "Pete_UK" wrote: Put this in C2: =INDEX(B6:D14,MATCH(A2,A6:A14,0),MATCH(B2,B5:D5,0) ) Hope this helps. Pete On Jun 5, 10:09 pm, rkenchel wrote: I have the following grid: A B C D 1 Elim Period Cost 2 0/14 6 ??? 3 4 Period 5 Elim 6 12 24 6 0/7 $4.85 $6.30 $8.00 7 7/7 $4.50 $5.95 $7.60 8 0/14 $3.95 $4.75 $6.60 9 14/14 $3.55 $4.35 $5.80 10 0/30 $2.90 $3.80 $5.15 11 30/30 $2.35 $3.15 $4.15 12 60/60 $0.00 $2.70 $3.50 13 90/90 $0.00 $2.05 $2.40 14 180/180 $0.00 $0.00 $1.60 A2 and B2 are drop down lists allowing selection of Elim and Period choices. They are both formatted as TEXT. I need to return the correct cost in C2 for the column-row selected by Elim and Period. I've read through other posts and it seems INDEX() or VLOOKUP() might be what I need, but I just can't seem to make them work. Thanks in advance for your assistance! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I retrieve Cost from a grid using text drop down lists?
You're welcome, Rog - thanks for feeding back.
Pete On Jun 5, 11:02*pm, rkenchel wrote: Thanks Pete!! I tried something similar off of another post that was combining the MATCHes into one and I could not make it work. Your solution was right on! Rog "Pete_UK" wrote: Put this in C2: =INDEX(B6:D14,MATCH(A2,A6:A14,0),MATCH(B2,B5:D5,0) ) Hope this helps. Pete On Jun 5, 10:09 pm, rkenchel wrote: I have the following grid: * * * * A * * * B * * * C * * * D 1 * * * Elim * *Period *Cost 2 * * * 0/14 * *6 * * * ??? * * 3 * * * * * * * * * * * * * * * 4 * * * * * * * Period 5 * * * Elim * *6 * * * 12 * * *24 6 * * * 0/7 * * $4.85 * $6.30 * $8.00 7 * * * 7/7 * * $4.50 * $5.95 * $7.60 8 * * * 0/14 * *$3.95 * $4.75 * $6.60 9 * * * 14/14 * $3.55 * $4.35 * $5.80 10 * * *0/30 * *$2.90 * $3.80 * $5.15 11 * * *30/30 * $2.35 * $3.15 * $4.15 12 * * *60/60 * $0.00 * $2.70 * $3.50 13 * * *90/90 * $0.00 * $2.05 * $2.40 14 * * *180/180 $0.00 * $0.00 * $1.60 A2 and B2 are drop down lists allowing selection of Elim and Period choices. They are both formatted as TEXT. I need to return the correct cost in C2 for the column-row selected by Elim and Period. I've read through other posts and it seems INDEX() or VLOOKUP() might be what I need, but I just can't seem to make them work. Thanks in advance for your assistance!- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
Validation - Drop Down Lists with tiny text | Excel Discussion (Misc queries) | |||
Text spacing in drop down lists | Excel Worksheet Functions | |||
How do i create an automatic monthly cash flow from lists of cost. | Excel Discussion (Misc queries) |