Hi there,
I have a little problem on arranging a small multi-worksheet excel here.
Let me explain in a short way then give some details on it.
I am trying to make an offers recordsheet which has two worksheets in it. One
for products(and their base prices) and an offer sheet. I would like to use
a bit dynamic data here. So when I type the name of the product excel would
give me the price from other worksheet.

in details;
Prices worksheet is something like:
A B
1 Product BasePrice
2 mouse 5
3 keyboard 8
4 ...

And the Offers sheet is like:

A B C D
1 OFFER1 blank blank blank
2 Product BasePrice Quantity Cost
3 mouse 5 2 10
4 keyboard 8 4 32
5 TOTAL 42

when i type mouse in A column I'd like excel to fill the BasePrice value
from Prices worksheet and when I change the value it keep updating the prices
on Offers worksheet.

Not sure if we need a macro to achieve this or not. Tried it with name
things, tried some vlookup but as you can guess I am stuck here. I'd be
thankful if someone could give me a hand here.

Thank you