Results 1 to 9 of 9

VLookup returning same data when multiples exist

Threaded View

  1. #1
    Registered User
    Join Date
    12-03-2010
    Location
    Melbourne
    MS-Off Ver
    Excel 2007
    Posts
    2

    VLookup returning same data when multiples exist

    Hi Gurus, I have spent a weekend trying to get the table attached to work using False, True, $ and the usual suspects. Any feedback to point me in the right direction would be id didly good.

    It seems to half work. Basically I am trying to do a Vlookup from one sheet to another. The aim is to send toner prices for customer requests. A customer usually tells me the model number of the printer they have. This would be used to pull in data using Vlookup to complete the description and price. The problem is one model number may have several or more toners so I need to include all these in the table. It seems to work at the beginning of the template returning the correct data when I have say model number 5 with 3 different toners but later it just keeps bringup the same data and not the corresponding data it should.

    Any ideas whats going wrong? Please help before I jump off a bridge!
    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