Prev: how do I print edge to edge with absolutely NO margins
Next: Returning a label rather than a number in pivot table field
From: jollyr on 10 Mar 2010 09:01
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 D6:D13, 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
From: Herbert Seidenberg on 11 Mar 2010 11:34
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

From: jollyr on 12 Mar 2010 08:54
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
>
> .
>
 | 
Pages: 1
Prev: how do I print edge to edge with absolutely NO margins
Next: Returning a label rather than a number in pivot table field