=SUMIF([parket.xls]parket'!$B:$B;B4;[parket.xls]parket'!$D:$D) is not working for me

Posted by Brynjar Hallmannsson on May 15, 2001 1:27 AM

I have this workbook, (ParketPrices) where I use values from another workbook, (Parket). The problem is that there can be identical value´s in row B in (parket) I don´t want to use the sum of these values. I need to get the first occurance and use that one in the other workbook (ParketPrices).
Regards,

Posted by Dave Hawley on May 15, 2001 1:51 AM

Hi Brynjar

Sounds like you need a Lookup formula, try VLOOKUP eg;
=VLOOKUP(B4,[parket.xls]parket'!$B:$D,3,FALSE)

..or have a look at INDEX and MATCH

Dave

OzGrid Business Applications

Posted by Brynjar Hallmannsson on May 15, 2001 3:37 AM

Thanks it´s working smoothly now =|;-)>--