Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to vlookup colume with different values
Hi,
I would like to use vlookup or other to number and match two lists, first is with number reference assigned date merchant amount ref. 05/16/09 1234 500.00 1 05/17/09 1234 600.00 2 second list merchant 1234 date amount 05/16/09 500.00 merchant 1234 date amount 05/17/09 600.00 thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to vlookup colume with different values
When you have multiple criteria use SUMPRODUCT()
=SUMPRODUCT((A1:A10=criteria1)*(B1:B10=criteria2), C1:C10) If this post helps click Yes --------------- Jacob Skaria "Bklynhyc" wrote: Hi, I would like to use vlookup or other to number and match two lists, first is with number reference assigned date merchant amount ref. 05/16/09 1234 500.00 1 05/17/09 1234 600.00 2 second list merchant 1234 date amount 05/16/09 500.00 merchant 1234 date amount 05/17/09 600.00 thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to vlookup colume with different values
I dont know how to go about formulate the formula, Please advice.
first spread sheet ABCD 1.date merchant amount ref. 2.05/16/09 1234 500.00 1 3.05/17/09 1234 600.00 2 second spread sheet ABCD 1.merchant 2.1234 3.date amount 4.05/16/09 500.00 5. 6.merchant 7.1234 8.date amount 9.05/17/09 600.00 "Jacob Skaria" wrote: When you have multiple criteria use SUMPRODUCT() =SUMPRODUCT((A1:A10=criteria1)*(B1:B10=criteria2), C1:C10) If this post helps click Yes --------------- Jacob Skaria "Bklynhyc" wrote: Hi, I would like to use vlookup or other to number and match two lists, first is with number reference assigned date merchant amount ref. 05/16/09 1234 500.00 1 05/17/09 1234 600.00 2 second list merchant 1234 date amount 05/16/09 500.00 merchant 1234 date amount 05/17/09 600.00 thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
alphabetical order in a colume | Excel Discussion (Misc queries) | |||
how to multiply entire colume? | New Users to Excel | |||
Colume Headings | Excel Worksheet Functions | |||
3 COLUME CHART | Excel Worksheet Functions | |||
How can I look up max of one colume and display the colume to the. | Excel Worksheet Functions |