Results 1 to 3 of 3

Thread: Lookup (2003)

  1. #1
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Lookup (2003)

    I don't even qualify as a novice with Excel, so I hope I can at least pose the question correctly.

    In the attached spread sheet (Fuel Pricing Data tab) I want to be able to enter the current price (col [img]/forums/images/smilies/cool.gif[/img] and have it find the correct percentage (col E) by looking in the "range" of prices shown in columns A and B (FSCscale tab) and the percentage shown in Col C. Gosh, I hope I said that right.

    Switching back and forth between the tabs to find the correct percentage has resulted in entry errors. Any help greatly appreciated.
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Lookup (2003)

    Enter this formula in E6:
    <code>
    =IF(ISBLANK(B6),"",VLOOKUP(B6+0.000000001,FSCscale !$A$3:$C$40,3))
    </code>
    And fill down as far as needed. The ISBLANK part is there to leave the result blank if nothing has been entered in column B yet. The +0.000000001 takes care of the small (invisible) rounding errors in FSCscale column A.

  3. #3
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: Lookup (2003)

    Hans,

    I'm really beginning to wonder if you're not my Guardian Angel (no matter what board I'm on)!
    It worked perfectly of course. Thanks, once again, for saving the day.

    Best Regards,
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •