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