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

Does programming mean formulas?

If yes, visit Debra Dalgleish's site:
http://www.contextures.com/xlFunctions03.html
(especially sample 2)
and
http://contextures.com/xlFunctions02.html#Trouble

Steve wrote:

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

--

Dave Peterson

With your table in A1:D4 (table exactly as you described, so A1 is empty),
the B in E1 and the Y in F1:

=INDEX(B2:D4,MATCH(E1,A2:A4,0),MATCH(F1,B1:D1,0))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Steve" wrote in message
...
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

Fantastic, thank you very much

"Niek Otten" wrote:

With your table in A1:D4 (table exactly as you described, so A1 is empty),
the B in E1 and the Y in F1:

=INDEX(B2:D4,MATCH(E1,A2:A4,0),MATCH(F1,B1:D1,0))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Steve" wrote in message
...
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

Thanks Dave

I mean't VB programming which I can kind of do.

However, this web site if great, just need to spend some time going over it
as I sometimes know what I want just don't know what functions can do what.

Appreciate you help

Steve

"Dave Peterson" wrote:

Does programming mean formulas?

If yes, visit Debra Dalgleish's site:
http://www.contextures.com/xlFunctions03.html
(especially sample 2)
and
http://contextures.com/xlFunctions02.html#Trouble

Steve wrote:

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

--

Dave Peterson
.