## Mapping multiplying problem

Marcus_230
Lounger
Posts: 37
Joined: 04 Oct 2023, 14:49

### Re: Mapping multiplying problem

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
Posts: 79321
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

### Re: Mapping multiplying problem

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

Marcus_230
Lounger
Posts: 37
Joined: 04 Oct 2023, 14:49

### Re: Mapping multiplying problem

Absolutely.

Marcus_230
Lounger
Posts: 37
Joined: 04 Oct 2023, 14:49

### Re: Mapping multiplying problem

Absolutely.

HansV
Posts: 79321
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

### Re: Mapping multiplying problem

See the attached workbook.

mapping_data_problem.xlsx
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

Marcus_230
Lounger
Posts: 37
Joined: 04 Oct 2023, 14:49

### Re: Mapping multiplying problem

Thank you very much.

Marcus_230
Lounger
Posts: 37
Joined: 04 Oct 2023, 14:49

### Re: Mapping multiplying problem

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.
You do not have the required permissions to view the files attached to this post.

HansV
Posts: 79321
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

### Re: Mapping multiplying problem

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

Marcus_230
Lounger
Posts: 37
Joined: 04 Oct 2023, 14:49

### Re: Mapping multiplying problem

Unfortunately it doesn't. Thank you.

HansV
Posts: 79321
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

### Re: Mapping multiplying problem

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
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

Marcus_230
Lounger
Posts: 37
Joined: 04 Oct 2023, 14:49

### Re: Mapping multiplying problem

Got it. Thank you very much.

HansV