Excel formula creation - help needed

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

  1. h2009 macrumors member

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

    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


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

    Feb 12, 2008
    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.


Share This Page