If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
add multiple returns using vlookup
Hi
I am using Vlookup function to find matching datat in another worksheet, i want to add values if there is more than one matching values. -- RZ |
#2
|
|||
|
|||
add multiple returns using vlookup
On Aug 22, 3:23 pm, RZ wrote:
Hi I am using Vlookup function to find matching datat in another worksheet, i want to add values if there is more than one matching values. -- RZ Can't. Try DSUM or SUMPRODUCT instead. |
#3
|
|||
|
|||
add multiple returns using vlookup
RZ wrote:
Hi I am using Vlookup function to find matching datat in another worksheet, i want to add values if there is more than one matching values. If the functions in the freely downloadable file at http://home.pacbell.net/beban are available to your workbook =SUM(VLookups(lookup_value, lookup_range, return_column)) Alan Beban |
#4
|
|||
|
|||
add multiple returns using vlookup
let me give u example
I am trying to find corresponding values of below numerbs from another worksheet : Sheet 1 Col A Col B 1500 1600 1700 1800 1900 1200 1400 1300 1100 and sheet2 has multiple vlues as below col A col B 1100 26 1100 45 1200 12 1200 23 1200 25 1200 31 1300 14 1300 23 1300 89 1400 24 1400 45 1400 45 1500 10 1500 15 1500 15 1500 45 1600 12 1600 12 1600 16 1600 87 1700 15 1700 18 1700 48 1700 56 1700 78 1800 10 1800 11 1800 45 1800 48 1800 59 1900 10 1900 15 1900 22 1900 48 1900 56 so i m trying to get the result in sheet 1 col A colB 1100 71 1200 91 1300 126 so on plese urgenly. thanks -- RZ "Spiky" wrote: On Aug 22, 3:23 pm, RZ wrote: Hi I am using Vlookup function to find matching datat in another worksheet, i want to add values if there is more than one matching values. -- RZ Can't. Try DSUM or SUMPRODUCT instead. |
#5
|
|||
|
|||
add multiple returns using vlookup
thanks Alan but its not working, its giving me only the last matching number
from lookup_range not the sum of all the matching values, and if i try to find exact match , its returning the first matching number! any other idea? I will have more than 1000 rows with from where i need to find the sum of matching values. -- RZ "Alan Beban" wrote: RZ wrote: Hi I am using Vlookup function to find matching datat in another worksheet, i want to add values if there is more than one matching values. If the functions in the freely downloadable file at http://home.pacbell.net/beban are available to your workbook =SUM(VLookups(lookup_value, lookup_range, return_column)) Alan Beban |
#6
|
|||
|
|||
add multiple returns using vlookup
RZ wrote:
Hi I am using Vlookup function to find matching datat in another worksheet, i want to add values if there is more than one matching values. Hi RZ, I think your description of the requirements threw everyone off the path... Try this in sheet1!B1 =sumif(sheet2!A:A, sheet1!A1, sheet2!B:B) |
#7
|
|||
|
|||
add multiple returns using vlookup
Thanks smartin, SUMIF is working fine , i m sorry if my explanation made it
difficult to resolve the problem. -- RZ "smartin" wrote: RZ wrote: Hi I am using Vlookup function to find matching datat in another worksheet, i want to add values if there is more than one matching values. Hi RZ, I think your description of the requirements threw everyone off the path... Try this in sheet1!B1 =sumif(sheet2!A:A, sheet1!A1, sheet2!B:B) |
#8
|
|||
|
|||
add multiple returns using vlookup
RZ wrote:
Thanks smartin, SUMIF is working fine , i m sorry if my explanation made it difficult to resolve the problem. No problem. Glad you found a solution! |
Thread Tools | |
Display Modes | |
|
|