Results 1 to 5 of 5

Excel 2007 : Lookup/Vlookup using two Lookup values

Threaded View

Rick K Lookup/Vlookup using two... 09-16-2010, 12:49 PM
NBVC Re: Lookup/Vlookup using two... 09-16-2010, 01:06 PM
Rick K Re: Lookup/Vlookup using two... 09-16-2010, 01:19 PM
NBVC Re: Lookup/Vlookup using two... 09-16-2010, 01:29 PM
Rick K Re: Lookup/Vlookup using two... 09-16-2010, 02:16 PM
  1. #1
    Registered User
    Join Date
    08-05-2009
    Location
    Buffalo, NY
    MS-Off Ver
    Excel 2007
    Posts
    70

    Lookup/Vlookup using two Lookup values

    The attached spreadsheet is a sales report (first tab) that we create with multiple customers who have multiple business lines. The second tab contains detaled data that shows payment deductions (charges) for each of those customers, by business line.

    The third tab is just a pivot table showing the total charges, by customer, by business line.

    I want to be able to lookup by customer number, the charge/deduction for each of the business lines. So I guess in essensce, since the cust# is not unique for each line, the lookup command has to look at the customer number AND the business line, then go over to the Pivot Table and see which charge amount matches the customer number and business line, and then return its value.

    I've researched the forums, and am becoming more confused as I go.

    Any help is appreciated.

    Thanks!
    Rick
    Attached Files Attached Files
    Last edited by Rick K; 09-16-2010 at 02:51 PM.

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