worksheet 1 has several columns with # 1-3
c1
1
1
2
3
2
1
3

same worksheet column d1 # from 1-29
d1
1
2
5
16
20
19
18
same worksheet column k1 is a code that I groups the data
k1
c1f1s3
c2f2s1
c1f1s2
s2f1s3
so forth

these codes are in another workhseet and are assigned a dollar amount per
code.
I need to return the $amount that pertains to the code. I have 4 sets
1st groups if column c1 is(1 or 2) and if d1 is (0 - 13), I need to look on
the other wrok sheet to find the amount that corresponds to code in columm
k1. 2nd group if column c1 ( is 1 or 2) and if columm d1( is 14-19) I need to
look on the other wrok sheet to find the amount that corresponds to code in
columm k1. 3rd group if column c1 is (3 or more) and column d1 is (0-13) I
need to look on the other wrok sheet to find the amount that corresponds to
code in columm k1. 4rd group if column c1 is (3 or more) and column d1 is
(14-19) I need to look on the other wrok sheet to find the amount that
corresponds to code in columm k1.
5th group if column c1 is (3 or more) and column d1 is (20) I need to
look on the other wrok sheet to find the amount that corresponds to code in
columm k1.

Hope this helps
--
Thanks ECF


"Eduardo" wrote:

Hi,
Please provide one example and the result you are looking for

"ecf123" wrote:

can someone help me. I have 4 tables that have four dirrerent conditions.
i need to return one answer if any of the contions are met. This is what if
have done but it did not work.
=if(c1<=2,and(d1<=13,vlookup(worksheet,if(c1<=2,an d(d1=13,vlookup(worksheet,if(c13,and(d1<=19,vloo kup(worksheet,if(c13,and(d119,vlookUp(worksheet, if(c13and(d119,vlookup(worksheet)))))))))))))
--
Thanks ECF