I don't know what you tried with VLOOKUP because it is a simple
application of that function.

Suppose your brand/product name is in column A and the discount % is in
col. B starting with row 2 and going to row 4. Suppose the value you
want to look up is in E2. Then, the formula you want is
=VLOOKUP(E2,A2:B4,2,FALSE)
Adjust the range references to match your own data.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...

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