Formula please if possible

[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

 

[Frank Kabel]

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

 

[Shona]

Thanks but unfortunately that didn't work as it's looking up not just Y6 but
Y6 to Y23 and the same applies to AA6 - AA23.

Cheers Shona


news:[email protected]...

 

[Frank Kabel]

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

 

[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

 

[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

know")

 

[Shona]

Cracked it!

Knew you would thank you very much indeed

Shona

 

[Frank Kabel]

Hi
glad to hear it works for you