Hello!

I use this formula to retrive prices from different pricelists. For the
first two pricelists i want to round of the price to zero decimals and for
the last one leave the price as it is from the pricelist. I use Windows XP
and Excel XP, Swedish version.

=OM(W10="Förnöd";INDEX(Prislista!$A$5:$AF$173;PASSA(X10&T10;Prislista!$A$5:$A$173&Prislista!$B$5:$B$173;0);PASSA(V10;Prislista!$A$4:$AP$4;1));OM(W10="Lös";INDEX(Prislista!$A$183:$K$285;PASSA(X10&T10;Prislista!$A$183:$A$285&Prislista!$B$183:$B$285;0);PASSA(V10;Prislista!$A$182:AP$182;1));OM(W10="Kli";INDEX(Kli!$A$3:$J24;PASSA(J10&N10;Kli!$A$3:$A$24&Kli!$B$3:$B$24;0);PASSA("Pris";Kli!$A$2:$G$2;1));0)))

PASSA=MATCH
OM=IF

Hope you understands what I mean

Tia

Ola Sigurdh