Hello together,

I have a problem which I can not solve.

I know how I can search and import datas from an other Excel Sheet wit
the help of the formula VLOOKUP but I don`t know how I can get th
information I need if I`m search in different Exelsheets for thi
information.

So my problem exactly is that I use for different Groups of Products
different Excel sheets, and I want now creat one sheet in wich I ca
insert in one Cell the number of the product and in the other on
automatically appear the price of the product.
So Excel have to search in all of my different sheets to find th
number of the Product with the right price.

I couldn`t until now not find any way to sove this problem, and it i
for me, because of other reasons, not possible to copy all my product
in one exel sheet.

Thanks a lot
Fran

--
Franz Muste
-----------------------------------------------------------------------
Franz Muster's Profile: http://www.excelforum.com/member.php...fo&userid=3136
View this thread: http://www.excelforum.com/showthread.php?threadid=51063