Report one value out of a range

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: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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top