Lookup function
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 |
Lookup function
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 |
Lookup function
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 |
Lookup function
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 |
Lookup function
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 . |
All times are GMT +1. The time now is 10:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com