+ Reply to Thread
Results 1 to 3 of 3

lookup function problem

  1. #1
    Registered User
    Join Date
    04-23-2011
    Location
    UK
    MS-Off Ver
    Excel Mac 2011
    Posts
    2

    lookup function problem

    Hi,
    On the spread sheet I have a table, with Level, unit range and value. When the number of units is entered in to B23, an IF formula gets the level it falls within (no problem here) and displays it in B26. Each level has a value, so in cell 29B I’m trying to use the LOOKUP function to display the value, basted on the info in B26.

    Problem is the Lookup up function does not seam to work when looking up the level values with a number that has been general from a formula. If I type the level number in, it works fine.

    I would be grateful for any help, spread sheet attached.
    Attached Files Attached Files

  2. #2
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: lookup function problem

    You are generating TEXT values in cell B26.

    Remove the quotation marks from the number values you want.

    You could use this in cell B29: =VLOOKUP($B$23,$B$2:$D$15,3,1)

    and this in B26: =MATCH($B$23,$B$2:$B$15,1)

    Here are some links you might find useful:
    http://www.excelfunctions.net/Excel-...-Tutorial.html
    http://www.excelfunctions.net/ExcelVlookup.html
    http://www.excelfunctions.net/ExcelMatch.html
    Last edited by Cutter; 04-23-2011 at 11:19 AM. Reason: Offered alternative formulas

  3. #3
    Registered User
    Join Date
    04-23-2011
    Location
    UK
    MS-Off Ver
    Excel Mac 2011
    Posts
    2

    Re: lookup function problem

    Hi, thanks vrey much. Im a bit of novies with excel so every day is a lerning day.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1