# Amount differs in result having same voucode

#### JAlandhar 201718

##### Member
hello sir, can you please help me in this formula as i need the different amount from the table, but it shows the same amount as of previous in last line of result, Help me please

#### Attachments

• 14.3 KB Views: 6

#### GraH - Guido

##### Well-Known Member
Hi,

The formula in N24 does not need to be an array formula.
You are using MATCH(L37,abc[VOUNO],0) so that finds the exact match.
Thus it will return the index for the first value found where L37 = abc[VOUNO], being 13. So the index part will always return 2017, since [VOUNO] with the value 195789 appears twice in your table.

Is it an error in the table, or do you need another formula to handle this scenario?

EDIT: possible like formula in file to handle 2 or more occurrences of [VOUNO] in table abc. Perhaps you'd need to do the same for table def.

#### Attachments

• 15.2 KB Views: 1
Last edited:

#### JAlandhar 201718

##### Member
Sir, with your help i updated my formulas, please check the result i get some blank values in response.

#### Attachments

• 32.6 KB Views: 3

#### GraH - Guido

##### Well-Known Member
Might be, replace this AGGREGATE(15,6,ROW(abc[VOUNO])/(abc[VOUNO]=L23)-1
by AGGREGATE(15,6,ROW(abc[VOUNO])/(abc[VOUNO]=L23)-5

#### JAlandhar 201718

##### Member
thanks for your kind help, it worked,

as if I use your formula in "V3" cell, it shows blank cell in result

#### Attachments

• 44.4 KB Views: 1

#### GraH - Guido

##### Well-Known Member
Hi, but here your table starts at row 22... and not row 5.

#### JAlandhar 201718

##### Member
thankyou sir, i will update here if i need any help again, thanks a lot once again
Hi, but here your table starts at row 22... and not row 5.