formula issue between cells
I have a issue with using a formula to look at another cell with a formula in
it and pulling the data correctly.
Column "L" has a formula (vlookup) pulling a cell over if it has a
particular symbol "HV".
Column "M" looks at "L" and if it equals 2 or 8 than it puts either of the
those numbers in "M" or leaves blank if it equals anything else.
Column "N" looks at "M" and pulls the data from column "J" if a 2 or 8 is in
"M".
My problem is Column "N" it seems, can't differentiate what is in column
"M". It seems it does not like the formula in "M".
Formulas being used:
Column
€śL€ť: =IF(ISNA(VLOOKUP($L$1,A2:H2,8,FALSE))=TRUE,"",VLOO KUP($L$1,A2:H2,8,FALSE))
Column €śM€ť: =IF(L2=2,"2",IF(L2=8,"8",""))
Column €śN€ť: =IF(M2=2,J2,IF(M2=8,J2,""))
--
Baltimore Ravens
|