Cell dependence?

[hristij4n]

I need help. I have problem.
in Sheet2 in Row B I have Names and in Row C Prices.
In Sheet1 in Row B I have dropdown list that is consisted of Row B in Sheet 2.
My question is, when I select something from the dropdown list I want Cell C* to be filled with the dependent price (lets say from the dropdow list cell B3 is selected and the corresponding price for it is C3). Thanks.

[StephenR]

This perhaps in column C of sheet1?

=VLOOKUP(B2,Sheet2!B1:C5,2,FALSE)

[excelforum123]

Hello,

I understood your query. This might help :

Enter the following formula in Sheet 1 Column C, which is exactly at the right of the dropdown cell.

Enter this formula in C2.

=vlookup(B2,Sheet2!C:C,1,0)

Then, it will return the Price value in C2 cell. It will be updated everytime you select a name from drop-down.

[hristij4n]

Thanks. But when I solved it I realised I need something else. The same problem but updated.
Lets say I have columns A, B and C. so I want when in A1 from the dropdown list is selected some item, B1 and C1 to be automatically fixed whit the appropriate values in Sheet2? Thanks.

[Marcol]

As stephen says above.

Here's a demo workbook using named ranges
=IF(B2="","",VLOOKUP(B2,PriceTable,2))

[StephenR]

Check out Excel Help for the VLOOKUP formula. It's pretty straightforward - come back if you get stuck.

[Marcol]

If you have a quantity in Column A this will calculate the total cost.

In C2

=IF(B2="","",VLOOKUP(B2,PriceTable,2)*A2)

Is this what you are trying to get?