LOOKUP dilema - Don't know where to start or how

N

NightProbe

I am looking for a way to lookup the value in a cell based on a value
in another. eg

A B C

1 3/12/05 12 V
2 3/13/05 10 P
3 3/14/05 12
4 3/15/05 12 S
5 3/16/05 12 S
6 4/2/05 12 V


The formula should identify the "month" in the date in column A and
the number in column B based on the corresponding value in column C

The results will be used to sum the values from column B and report it
to the appropriate month on another worksheet.


dentify
 
J

Jerry W. Lewis

Not sure that I follow your description, but
=SUMPRODUCT((MONTH(A1:A6)=3)*(C1:C6="V"),B1:B6)
will sum the values in column B that correspond to "V" in column C and
March dates in column A.

Jerry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Returning a Date with Multiple Criteria Lookup Values 0
Update cell value based on name and specific date 0
IF ARRAY with multiple conditions. 1
Sumif does not work 2
Check if a date comes before/after a range of dates 0
How to build subquery on aggregate query 0
Modifying a complex date formual to count months 4
Help with If Sum statement - i think.... 4

Top