Results 1 to 3 of 3

Excel 2007 : Nesting VLookup Function or alternative?

Threaded View

  1. #1
    Registered User
    Join Date
    02-25-2011
    Location
    Baltimore, MD
    MS-Off Ver
    Excel 2007
    Posts
    2

    Nesting VLookup Function or alternative?

    So I have a sheet where there is an item code in a column... within that item code is a range of zip codes in another column, and next to each zip code is a corresponding price.

    What I am trying to accomplish is to have one cell where you can enter the item code, and another cell where you can enter the zip code, and the appropriate price will show up.

    I have been going crazy trying to nest a vlookup within a vlookup where I can get an exact match to the item code, and a ranged match to the zip code (since we only look at the first three numbers) and have been having zero luck figuring this out.

    I've attached a basic version of the file which should give you an idea.

    Any thoughts?
    Attached Files Attached Files

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