LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Hybrid vlookup - sum function

Hi,

I have two tables that each have 2 columns. The first column in the first
table is composed of dates that are in ascending order, but have some
duplicate dates and missing dates. The second column has numbered values. The
first column in the second a table is all dates 1/1/08 to present. I want the
second column to be an output of a function. The first part of the function
is easy and would find a date in the first table and return the corresponding
column 2 value. The tricky part is that when there are two dates, or more
than one, then I want the output be the sum of the column 2 values. Does this
make sense? Thanks for your help.

John
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP buffgirl71 Excel Discussion (Misc queries) 12 November 14th 06 11:36 PM
How to sort text and letter hybrid (eg A1, A2, A10) in order? Amy Excel Worksheet Functions 0 March 21st 06 06:39 PM
HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION CHAIM Excel Worksheet Functions 1 July 27th 05 09:10 PM
how do I write a vlookup function within an iserror function so t. JBLeeds Excel Worksheet Functions 2 March 16th 05 10:30 AM
I want to use Vlookup function and AND function in a single formu. prakash Excel Worksheet Functions 3 January 25th 05 07:11 AM


All times are GMT +1. The time now is 04:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"