S
Steve
Hi
I have a matrix of products and pricing, upgrades etc.
X Y Z
A 10 20 30
B 25 35 50
C 15 40 75
What I need to do is similar to the HLOOKUP but that does not give me what I
need.
What I want is a function where I give it the name of the prouct (A, B or C)
and what product I'm upgrading to (X, Y or Z) and it give me the value. e.g.
B & Y = 35.
I guess it like an intersection function.
Is there such a way of doing this with programming?
Thanks
Steve
I have a matrix of products and pricing, upgrades etc.
X Y Z
A 10 20 30
B 25 35 50
C 15 40 75
What I need to do is similar to the HLOOKUP but that does not give me what I
need.
What I want is a function where I give it the name of the prouct (A, B or C)
and what product I'm upgrading to (X, Y or Z) and it give me the value. e.g.
B & Y = 35.
I guess it like an intersection function.
Is there such a way of doing this with programming?
Thanks
Steve