Formula please if possible

S

Shona

Hi

Hope you can help

The formula in column C6 needs to be if B6 matches what is involumn Y and
the figure in W6 matches what is in Column AA put what is in column Z

This is the array but there are 18 variations but haven't listed them all

Y Z AA

A A + A 100
A AA 150

B A + B 100

B AB 150

Any ideas would be great

Thanks Shona
 
F

Frank Kabel

Hi
maybe the following is hwat you're looking for
=IF(AND(B6=Y6,W6=AA6),Z6,"don't know")
 
F

Frank Kabel

Hi Shona
then try
=IF(AND(COUNTIF(Y6:Y23,B6)>0,COUNTIF(AA6:AA24,W6)>0),Z6,"don't know")
 
S

Shona

Sorry this is probably my fault for not explaining it very well there are 18
rows all different in Column Z

I'm surely you are nearly there

Thanks again Shona
 
F

Frank Kabel

Hi
o.k lets continue guessing :) Better would be if you would explain
again but you may try the following array entered formula (entered with
CTRL+SHIFT+ENTER)

=INDEX($Z$6:$Z$24,MATCH(B6&W6,$Y$6:$Y$24&$AA6:$AA24,0))

this will get the value from column Z in the row there the value from
col. AA equals W6 and the value from col. Y equals B6


--
Regards
Frank Kabel
Frankfurt, Germany

Sorry this is probably my fault for not explaining it very well there
are 18 rows all different in Column Z

I'm surely you are nearly there

Thanks again Shona
Click to expand...
know")
 
Top