Results 1 to 2 of 2

Thread: VLookup

  1. #1
    Join Date
    Oct 2003
    Posts
    29

    Unanswered: VLookup

    Can you have a vlookup inside a vlookup? I'm trying to find in a table of data, where more than one thing is equal, and then I want to add or sum those values up.

  2. #2
    Join Date
    Feb 2006
    Posts
    113
    bailee220,

    There will be a way, though not VLOOKUP inside another VLOOKUP. VLOOKUP returns a single value.

    Depending on if the data is sorted, maybe an OFFSET & COUNTIF could refer to the summation range. OFFSET is volatile. If you have many thousands of these it may not be too efficient. And working across worksheets is also not optimally efficient.

    Have you considered a query table - you could do the hard work in SQL - very smart. And/or a pivot table?

    Or SUMIF, maybe also using COUNTIF. Maybe use DSUM, etc.

    Or even VBA coding.

    There are probably many ways. Depends on your requirements.

    Hope that gives you enough leads.

    If you want more specific suggestions, please post details of your requirements.

    regards,
    Fazza

Posting Permissions

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