Hi Stefi:
You are really GEM, the formula you gave is excellent and made my sheet
perfect and while coping it so easy rather than others which I had. I just
came back to appreciate as I realize the worth of skilled and profisional
brains.
Wish you all the best.Iraj

"Stefi" wrote:

You are welcome! Thanks for the feedback!
Stefi

€žIraj€� ezt Ã*rta:

Thanks Stefi with this also works.

"Stefi" wrote:

=INDEX(Sheet2!$A$1:$D$4,MATCH($A2,Sheet2!$A:$A,0), MATCH($B2,Sheet2!$1:$1,0))

Regards,
Stefi

€žIraj€� ezt Ã*rta:

Hi again all:
I have in sheet 1;(Material Costs)
A B C
1 Items Seller Price
2 Sand Dropdown List
3 Cement Dropdown List
4 Bars Dropdown List

I have in sheet 2;(Sellers)
A B C
D
1 Items Mick Sam
Jim
2 Sand 2$ 3$
2.5$
3 Cement 5$ 5.2$
4.9$
4 Bars 12$ 10.5$
11$

Units are same. What formula in sheet 1, can i write that when dropdown list changes the name the exact price of the related seller's name appears in C2:C4 respectively?

I tried with IF combination with VLOOKUP which result was #NAME?
Thanks for instruction.