Formula Help

B

Boenerge

Hi,
I have a data sheet that contains a list of different departments in one
cloumn (column B). In the rows I have recorded if the area has met a target
with a "Y", if they haven't it is left blank.

I want to set up a formula in a cell to look for a certain department in
coumn B e.g. 1a, then for the formula to look across to see if the criteria
has been met

Column
B C D E F G H
I
ROW 4 1a PGI Y Y
5 12 DDH Y Y Y

6 1a PGI Y Y Y

So in this example I would want the formula to look up "1a" in column B and
then look across both rows to criteria F and return the value of 2.

Thanks in advance
Jason Alcorn
 

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