Hi all, Is it possable for a formula through vba to find another workbook, without haveing to have the path in the formula. This is what I have. Thx Dan

=IF(A2>=1,VLOOKUP(A2,'C:UnitpricingUsPrice1.xls'!CS,2,FALSE),"")