If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Report one value out of a range
Hello everyone. I have the following scenerio that I sure could use some help
on: A B C D E 1 Mike tools Sam tools 2 Tom bike 3 Mike bed 4 5 Sam tools ab2 6 Sam bike ab3 7 Sam bed ab4 8 Tom tools ab5 9 Tom bike ab6 10 Tom bed ab7 11 Mike tools ab8 ab8 12 Mike bike ab9 13 Mike bed ab10 Cells A1 & B1 are each list boxes, drawing from the lists on D1,2&3 and E1,2&3. In cell D5 I have the formula: =IF(AND(A5=$A$1,B5=$B$1),C5,"") This formula also exists in cells D613, using the appropriate adjacent cells. In this way, only one cell will be populated in this range, if the exact pairing of the adjacent cells is chosen in the above list boxes. I am trying to figure out how to make D14 show whichever cell is populated in the range of cells above it. Obviously there will never be more than one cell in that range populated at a time and I need to have that reported value in D14. Thank you in advance for any help I may get! -- jollyr99 |
#2
|
|||
|
|||
Report one value out of a range
Excel 2007 only
Tables, Index/Match http://www.mediafire.com/file/zitomeztjtl/03_11_10.xlsx Pdf preview: http://www.mediafire.com/file/wturzwwkx5w/03_11_10.pdf |
#3
|
|||
|
|||
Report one value out of a range
I love the method that you used to answer my question!
Thank you so much! -- jollyr99 "Herbert Seidenberg" wrote: Excel 2007 only Tables, Index/Match http://www.mediafire.com/file/zitomeztjtl/03_11_10.xlsx Pdf preview: http://www.mediafire.com/file/wturzwwkx5w/03_11_10.pdf . |
Thread Tools | |
Display Modes | |
|
|