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.
|