I was using excel's =DSUM database function to lookup multiple occurrences of a transaction number and sum an amount located in another column each time the transaction number was found. Though this procedure worked great when the worksheets contained only a few hundred lines, my spreadsheet is...
I need a function similar to Excel's standard vlookup function where I can lookup a value in cell A1 of Sheet 1 in a range located on Sheet 2 and once it finds a match return a value located in column C on Sheet 2. However, there may be more than one exact match in the range located in Sheet 2...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.