Sorry guys, I don't really succeed to understand how to apply the
VLOOKUP in what I want to do:

I have a price list with item name, code, price and discount.

I need to do an economical offer IN A SEPARATE SHEET and I would like
that when I type a certain code article, it would give me its price and
its discount, based on the other separate excel sheet.
As far as I am seeing, VLOOKUP cannot connect different sheets can it?

Do I have to use the VBS functions?


I don't want to use access, cause I prepare the economical offers in
excel, so rather than going to look for the price and discount of a
certain article in other excel files, I want to create queries and
assignations and connect databases in excel. I know it is possible to
do it, I just need to find out how.
I know it's a quite difficult operation, anyway,
Thank you very much


--
number


------------------------------------------------------------------------
number's Profile: http://www.excelforum.com/member.php...o&userid=24949
View this thread: http://www.excelforum.com/showthread...hreadid=384832