Lisa_King_3
New Member
- Joined
- Jan 26, 2004
- Messages
- 39
Hi people
I have a set table in one worksheet, with three columns: Age, Type and Fee. The table has 12 rows, with a combination of ages, types, and prices.
In another worksheet, i have the weeks sales. This table has column headers: age, type, fee.
I need a formula that will return a the value in the third column(fee) on the first sheet, if the text in the first two columns(age and type) match up with the text in the first two columns of the table for the weekly sales?
I have tried to do it with IF and AND functions, but i come up with really long formula's that don't work? I hope you can help me.
I thought that maybe i could do it using VLookup, but i dont know how to do VLookup with looking up the value in two columns rather than just one?
Lisa x
I have a set table in one worksheet, with three columns: Age, Type and Fee. The table has 12 rows, with a combination of ages, types, and prices.
In another worksheet, i have the weeks sales. This table has column headers: age, type, fee.
I need a formula that will return a the value in the third column(fee) on the first sheet, if the text in the first two columns(age and type) match up with the text in the first two columns of the table for the weekly sales?
I have tried to do it with IF and AND functions, but i come up with really long formula's that don't work? I hope you can help me.
I thought that maybe i could do it using VLookup, but i dont know how to do VLookup with looking up the value in two columns rather than just one?
Lisa x