+ Reply to Thread
Results 1 to 5 of 5

vlookup pricelist question

  1. #1
    Registered User
    Join Date
    03-30-2008
    Posts
    9

    vlookup pricelist question

    Im writing a new pricelist, and need to be able to find an exact height and width for a door within the pricelist
    See pic attached for a look at the pricelist and more details.

    Thx in advance for any help offered.

    Gordon
    Attached Images Attached Images
    Last edited by ministerofdeath; 03-30-2008 at 02:04 AM.

  2. #2
    Registered User
    Join Date
    03-24-2008
    Posts
    11
    Set the last parameter for VLOOKUP to TRUE. This will pick up the next bigger size from the table.

  3. #3
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161
    Ministerofdeath, Welcome to excel forum!, if you must cross post in other forums please supply the links ( you should do this in all forums you have posted in) as i have done here with this particular one.
    http://www.mrexcel.com/forum/showthread.php?t=311564

    People who help on these forums often frequent dozens of other forums and if they see a cross post without the link you are not likely to get much help!
    Not all forums are the same - seek and you shall find

  4. #4
    Forum Contributor vandanavai's Avatar
    Join Date
    09-04-2006
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    256
    Hello

    Check out if attached filr help u. Be sure that Height and Width are arranged in descending order.
    Attached Files Attached Files

  5. #5
    Banned User!
    Join Date
    10-14-2006
    Posts
    1,211
    Quote Originally Posted by ministerofdeath
    Im writing a new pricelist, and need to be able to find an exact height and width for a door within the pricelist
    See pic attached for a look at the pricelist and more details.

    Thx in advance for any help offered.

    Gordon
    See the attached
    Attached Files Attached Files

+ 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