Xlook up

Resolved · Medium Priority · Version 365

Mon 31 Oct 2022, 11:29 Delegate Holly said...

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?

Tue 1 Nov 2022, 13:52 Trainer Martin said...

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)