look up on several sheets from three variables

[tcmuell]

Hi i am new to the forum and i am looking for some assistance with a formula to return a rate for a product from several different suppliers.

I need a return value based on 1. a cell indicating who the supplier is (ABC below), 2. based on the supplier code (dke below) and 3. the number of the product (33 below).
So i have seperate sheet for each supplier and need the formula to determine the sheet to look at from cell 1 (supplier) go to that sheet and then return a value for the product number (33) based on the supplier code (dke).

if text in cell a1 on sheet 1="ABC" then look for sheet "ABC"
if text in cell a2 on sheet 1= "dke" then return value for product number 33 indicated on cell c4 sheet 1 from sheet "ABC"

I really appreciate any assistance you can give me, even if it is just getting me started.

Edited to include file...thank you and sorry for not posting immediately.

[oeldere]

You get better help on your question if you follow the advice in the link below.

http://www.excelforum.com/the-water-...-question.html

[tcmuell]

i just uploaded it. thank you for the advice and sorry for the ignorance, i should have read the link prior to posting.