Hi,
Is there a way to use VLOOKUPS to find a selection of the same reference and add them together to give you a result?
For example.
I've got this list of Holidays that need to be covered.
In Colomn L I have Vlookups that are taking data from another table. In this table the first colomn is "Contract number covered" So it will match the contract number in this table. Now this would be easy if it was just one cover for each holiday but I have multiple covers for each holiday. For instance... Contract #10001 has 3 different covers, so there will be a list in my 2nd table that have 3 rows using contract #10001 , one has 14 days covered the other 2 have 3 days covered each, but it's only pulling data from the first cover which is 14 days.
So my VLookup in L Column is "=VLOOKUP([@[Contract'#]],Table2,10,FALSE)"
Is there a formula to use to calculate any matching contract number together to give a total?
Thanks in advance,
Andy
Is there a way to use VLOOKUPS to find a selection of the same reference and add them together to give you a result?
For example.
![Capture4.jpg](/board/proxy.php?image=https%3A%2F%2Fpreview.ibb.co%2Fkj1Nfn%2FCapture4.jpg&hash=35ec2a41f86411b416cf23452862390a)
I've got this list of Holidays that need to be covered.
In Colomn L I have Vlookups that are taking data from another table. In this table the first colomn is "Contract number covered" So it will match the contract number in this table. Now this would be easy if it was just one cover for each holiday but I have multiple covers for each holiday. For instance... Contract #10001 has 3 different covers, so there will be a list in my 2nd table that have 3 rows using contract #10001 , one has 14 days covered the other 2 have 3 days covered each, but it's only pulling data from the first cover which is 14 days.
So my VLookup in L Column is "=VLOOKUP([@[Contract'#]],Table2,10,FALSE)"
Is there a formula to use to calculate any matching contract number together to give a total?
Thanks in advance,
Andy
Last edited: