Holly has attended:
Excel Advanced course
Xlook up
Hi,
I am trying to use the Xlookup function on a cash burn document, however it is only showing results for one cell.
The excel sheet has multiple sheets for different bank statements, with individual transaction lines. I assign these to a category. What I need the Xlookup to do is when the category is mentioned in Column E, To add the numbers together from Column C. However, it is not adding the values up from various transaction lines with the same category. How would you suggest doing this?
RE: Xlook up
Hi Holly
Thank you for your question
It looks like you can use the SUMIF to get your answer. I don't think the XLOOKUP would work in this case because it only applies to unique values and your example has the category name appearing multiple times, as I understand it. Let's say your category was CATEGORY A in Column E and all the values in Column C were Costs. The formula would look something like:
=SUMIF(E:E,"CATEGORY A",C:C)
This would sum all the Category A costs
I hope this helps. Please let me know if it has worked or if you need more assistance
Kind Regards
Martin Sutherland
(MOS Applications Trainer)
