J
jollyr
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
13, 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!
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
13, using the appropriate adjacent cells. In thisway, 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!