populating a cell from a value chosen in another

[mtec]

Hi,
I’m wondering if anybody would be able to help me out.
I have a takeoff sheet with drop down boxes to select an item from a from a parts list, that is located on the next sheet.
When an item is selected from the drop down box on the take off sheet I would like the next cell to be populated with its corresponding price from the parts list.
I've attached a file show what i'm trying explain.
Any Information would be much appreciated

[TMS]

=VLOOKUP(A2,'Parts List'!A:B,2,FALSE)


Regards

[royUK]

Use VLOOKUP

In your example I have formatted the parts list as a Table called PartsList, this means you can continue adding items which the formula will pick up automatically.

I've used this formula

=IF(ISBLANK(A2),"",VLOOKUP(A2,PartsList,2,0))

[mtec]

Thanks for the reply,
I use =VLOOKUP(A2,'Parts List'!A:B,2,FALSE) and it worked,
but like the idea of use a table that I can continue adding items which the formula will pick up automatically.
But couldn't get =IF(ISBLANK(A2),"",VLOOKUP(A2,PartsList,2,0)) to work.
I created a table on the parts list sheet.

[royUK]

Here's an example.

There's a good article on Tables here

And Dynamic Named Ranges