Excel formula creation - help needed

Discussion in 'Mac Apps and Mac App Store' started by h2009, Jun 18, 2008.

  1. h2009 macrumors member

    Joined:
    Oct 13, 2007
    #1
    Hi there, Im trying to find the formula which will look a lookup and return a result i.e. heres a simple example:

    Code:
    
    Row A                Row B	   Row C
    
    bulb 1                0.152	   0.227
    bulb 2                0.149	   0.224
    bulb 3                0.034	   0.051
    bulb 4                0.148	   0.222
    bulb 5                0.022	   0.033
    
    Row A                Row  B                                           Row C   Row D
    Bulb cost  ----->  (i want to type in bulb X) > returns with	   0.034	0.051
    
    
    Is it possible to make a formula which can do this?

    thank you
     
  2. CanadaRAM macrumors G5

    CanadaRAM

    Joined:
    Oct 11, 2004
    Location:
    On the Left Coast - Victoria BC Canada
  3. exegete77 macrumors 6502a

    Joined:
    Feb 12, 2008
    #3
    Keep in mind that VLOOKUP works fine as long as the lookup values are alphabetical and it is the left hand column. To get around those problems, use the much more flexible INDEX/MATCH combination., which allows lookup based on any row or any column.

    =INDEX(Data,MATCH(ColAValue,ColA,FALSE),MATCH(RowValue,Row,FALSE)
     

Share This Page