INDEX MATCH Functions in LibreCalc (Excel) - Non unique valuesreturn wrong index result
 

Hi,

i have this problem on both Excel 2010 and LibreOffice Cal.

I have 2 worksheets, the first is jsoneuro and the second is called
results

In the jsoneuro worksheet i have the following columns:

currency;symbol;bid;ask;volume;xrates;bid euro;ask euro;

With let's say the following data:

AUD;mtgoxAUD;28.16638;29.25356;11617.1698751;1.276 3;22.0687769333;22.9205986053
AUD;weexAUD;14;28;0;1.2763;10.9692078665;21.938415 733

In the results worksheet i have the following columns:

BUY HERE;‚¬ ASK PRICE;ORIG. ASK;

With let's say the following data:

ruxumJPY;3.9843877053;490;
ruxumHUF;4.4436848402;1300
ruxumHKD;6931372645;48;


In the BUY HERE column i'm using the following function (where INDICE is
INDEX and CONFRONTA is MATCH - italian version):

=INDICE($jsoneuro.B$2:$jsoneuro.B$100;CONFRONTA(B2 ;$jsoneuro.H$2:H$100;0))

This allows me to retrieve the marketplace name from jsoneuro worksheet
where i have a match with the value contained in the cell B2 of my
results worksheet.

The function i have in my ‚¬ ASK PRICE column is the following (PICCOLO is
SMALL and RIF.RIGA is the ROW REFERENCE):

=PICCOLO($jsoneuro.H$2:H$55;RIF.RIGA($jsoneuro.H2) )


The issue i have is that when i have a non unique value in my column B
(‚¬ ASK PRICE) my worksheet returns always the first result of the match
and not the corresponding one.

How can i sort out this issue?

Thanks for your effort and help.

Regards.
MM.