Re: Lookup function

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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
.

Relevant Pages

  • Lookup function
    ... I have a matrix of products and pricing, upgrades etc. ... I guess it like an intersection function. ... Is there such a way of doing this with programming? ...
    (microsoft.public.excel.worksheet.functions)
  • Re: 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: ... Kind regards, ... I have a matrix of products and pricing, upgrades etc. ... I guess it like an intersection function. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Lookup function
    ... Microsoft MVP - Excel ... I have a matrix of products and pricing, upgrades etc. ... I guess it like an intersection function. ...
    (microsoft.public.excel.worksheet.functions)
  • MS Visual Basic 6.0 Professional Edition upgrades
    ... I do a lot of serious programming in Access databases, ... I am asking what upgrades have ... Do I need to purchase a particular one or are there free ...
    (microsoft.public.vb.general.discussion)
  • Re: New to Group
    ... or can you make some upgrades? ... (I don't even know if eVC3 supports a ... You need to provide more detail than "better programming." ... Recently I have given an assgiment to develop an application for wince ...
    (microsoft.public.windowsce.embedded.vc)