Mapping multiplying problem

[Marcus_230]

Yes, I agree. But for me, this was absolutely amazing experience. Like I mentioned in the previous comment, what to do, if there are multiple numbers assigned to 1 ID? Your calculation correctly pulls the correct number associated with the deposit value, but what if I want to pull the other 3 numbers associated with the same ID and no values? In other words, showing zeros? Is it even possible?

[HansV]

Would it be OK to add the amounts from Table2 to the right of Table1 on the first sheet?

[Marcus_230]

Absolutely.

[Marcus_230]

Absolutely.

[HansV]

See the attached workbook.

mapping_data_problem.xlsx

[Marcus_230]

Thank you very much.

[Marcus_230]

Good morning Hans,

I have found out that their database is using Excel 2019, so that is why XLOOKUP will not work. I tried VLOOKUP but the formula will not take it. Not sure, where I am making a mistake. Also and assume, it is due to the UNIQUE keyword, sometimes there are 3-4 numbers assigned to the same ID. Is there a way to do it, so if that is the case, the ID will pull additional rows with different numbers to the same ID? I am attaching a screenshot for a visualization. thank you.

M.

[HansV]

The workbook in my previous reply should work in Excel 2019. It doesn't use any functions from later versions.

[Marcus_230]

Unfortunately it doesn't. Thank you.

[HansV]

I meant this workbook attached below. It only uses COUNTIF (which has been in Excel since the beginning) and SUMIFS (which was introduced in Excel 2007), and no other functions.

mapping_data_problem.xlsx

[Marcus_230]

Got it. Thank you very much.

[HansV]

It's exactly the same workbook as in post# 318248 higher up in this thread...