Hello,
I am using Vlookup to locate a few products and find out
their sales price, from another excel worksheet
(sales_historic) with a list of all products. In the
bigger excel worksheet(sales_historic), as product may
repeat itself many times, because it was sold many times.
I just need the last sales price of the product. When i
use vlookup function, i geta return of '#REF!'
any ideas, what i should do to get the values and not this.

thanks a lot for any help.
Samantha
=VLOOKUP(A2;sales_historic!C2:C661;16;FALSE)