lyhue802002
New Member
- Joined
- Jul 6, 2003
- Messages
- 26
Hi experts,
I need to come out a simple formula to seek data.
Sample table:
Group Key Value
X A 2
X B 4
Y AA 5
Y BB 10
The explanation goes like this:
1) I have 2 parameters
2) Parameter value 1 comes from a column named "Group"
3) Parameter value 2 comes from which group that user choose from.
4) The output value would be based on the table provided.
5) Example: If user choose group "X" and select "A"; so the output would
be 2.
What is the simplest way to solve this?
experts please advice. TQ
I need to come out a simple formula to seek data.
Sample table:
Group Key Value
X A 2
X B 4
Y AA 5
Y BB 10
The explanation goes like this:
1) I have 2 parameters
2) Parameter value 1 comes from a column named "Group"
3) Parameter value 2 comes from which group that user choose from.
4) The output value would be based on the table provided.
5) Example: If user choose group "X" and select "A"; so the output would
be 2.
What is the simplest way to solve this?
experts please advice. TQ