RECHERCHEV adds multiple rows with the same name
Solved
pfl.bourde
Posted messages
13
Status
Membre
-
pfl.bourde Posted messages 13 Status Membre -
pfl.bourde Posted messages 13 Status Membre -
Hello,
I have an Excel file with case numbers in column A, invoice numbers in column B, and invoice amounts in column C.
There can be several invoices for the same case number, so multiple rows for the same case. Example:
Case Invoice Amount
121212 011065 500.00
121212 021065 500.00
121212 031065 500.00
In another file where case numbers are listed, I would like to perform a VLOOKUP to retrieve the total amount of invoices by case.
PROBLEM: When I perform a VLOOKUP by case, the formula only takes into account the first line that contains this case number and does not sum all the lines.
VLOOKUP(121212;A2:C4,3,FALSE) = 500.00 and not 1500.00.
What formula could we use to sum the amount of all invoices corresponding to the case number 121212?
Thank you in advance for your answers!
Best regards.
I have an Excel file with case numbers in column A, invoice numbers in column B, and invoice amounts in column C.
There can be several invoices for the same case number, so multiple rows for the same case. Example:
Case Invoice Amount
121212 011065 500.00
121212 021065 500.00
121212 031065 500.00
In another file where case numbers are listed, I would like to perform a VLOOKUP to retrieve the total amount of invoices by case.
PROBLEM: When I perform a VLOOKUP by case, the formula only takes into account the first line that contains this case number and does not sum all the lines.
VLOOKUP(121212;A2:C4,3,FALSE) = 500.00 and not 1500.00.
What formula could we use to sum the amount of all invoices corresponding to the case number 121212?
Thank you in advance for your answers!
Best regards.
Simple, effective, I hadn't thought of that.
Have a good day!