vlookup and sum

  1. T

    Pls help Need to sum some "characters"

    Sorry, may be it's written somewhere but I didn't find... :( I need to sum some letter but on each letter corresponds number. I can make it with vloookup, but there will be many vlookups, can you help me to make it better... this sample table: <tbody> d d n n h p p d 8...
  2. M

    vlookup to sum different columns....BUT....

    HELLO EXCEL fans & pro's i have a have a matrix in a separate sheet a9:bb70 [where columns c9:bb9 are the 52 weeks of the year] each row [9 to 70] represents totals [hours] of a particular project in any of the 52 weeks i have another sheet where a user can select a period of time [start...
  3. M

    SUMIF & VLOOKUP Function

    Dear helpers, I am having difficulty creating a formula that I believe requires both a SUMIF and VLOOKUP function. I have been looking through other forums and Excel online help for a solution however haven't found one. My table looks like this: <colgroup><col style="width: 85pt...
  4. D

    Sum of Values Accross Multiple Columns in Multiple Worksheets Using VLOOKUP

    Hello, I am looking for the proper syntax to generate a sum of the bottom-most cell in each column across multiple worksheets. My current formula looks like this: =VLOOKUP(9.99999999999999E+307,'Z:\Warehouse\Inventory 2013\Spray Pens\[Spray Pens.xls]Anti-Static'!D$1:D$300,1) but the above...
  5. J

    Theatre Booking System query. vlookup?

    Hi, I am hoping I could get some assistance with an issue I am having on Excel! Let me start by saying I have searched other topics within the forum and can't seem to find the code which suits what I need...so here goes I have been trying to use a vlookup and a sum formula to find a show name...
  6. A

    Creating a VLookUp Function in VBA

    Hi all, First time poster here, so please let me know If I'm leaving anything out. Im trying to write a code in vba in Excel 2010 that would incorporate the vlookup function in excel. My Data Looks like this: <TABLE style="WIDTH: 384pt; BORDER-COLLAPSE: collapse" border=0...
  7. J

    VLOOKUP - Returning a sum of values from multiple sheets in workbook

    Hi there...:rolleyes: I'm trying to figure out how to return multiple values, added together, from a vlookup formula. Here is the scenario... Sheet 1 - called "Master Client Spend" <TABLE style="WIDTH: 256pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0...
  8. L

    VLook up & Sum

    When you do a v look up, how can you sum if you have more than one row with the same name. For instance: Column A Column B ExampleA $200 ExampleB $300 ExampleA $100 So if i do a =VLookUp(ExampleA,spreadsheet,A:B,2,0) =200 How can I do to get 300 which is the total of ExampleA...

Some videos you may like

This Week's Hot Topics

Top