If function with 3 condtions

Closed
Report
-
 Trowa -
Hello,
Wonder if somone could help me,
I need to write a if function to return a value based on 3 conditions
eg:
A B C D
1TOM DICK HARRY
2 1 4 7 10
3 2 5 8
4 3 6 9
5 20 22 24 26
6 21 23 25

columns A B C are arranged to a drop down combo box so when u drop down to 1 in column 1(TOM) and 4 in column 2 (DICK) cell G5 will be 1 and H5 will be 4 etc.

so the function should be if G5=A2:A4, AND IF H5=B2:B4, AND IF I5=C2:C4 then value to be returned is 10, if G5=A5:A6 and If H5=B5:B6 then value to be returned is 26. Can this be done?

I tried following function but it wouldnt work =IF(AND(G55=A2:A4),IF(AND(H5=B2:B4),IF(AND(I5=C2:C4),10,"Check")))

Please help

1 reply

Hi CL

Why compare a single cell to a range of cells, don't you want the function to do this:

G5=A2, if false "Check", if true next line
H5=B2, if false "Check", if true next line
I5=C2, if false "Check", if true D2

=IF(G5=A2,IF(H5=B2,IF(I5=C2,D2,"Check"),"Check"),"Check")

Best regards,
Trowa
0