Calling data from one sheet to another

[mshort]

Hi guys,

I'm stuggling with something which I'm sure should be quite basic. I have tried to adapt resoloutions from other threads to match my needs and I dont seem to be having any luck.

All I want to do, is call one cell on sheet1, to another in sheet2, based on a selection from a dropdown list. I have attached the spreadsheet I am working on so you can see what I mean.

I want to select the Part Number on sheet2 and pull the appropriate description from sheet1 (and possibly also the price)


Thanks,

Martyn

[brokenbiscuits]

=VLOOKUP($B3,Sheet1!$B:$F,3,FALSE)
for the description

and
=VLOOKUP($B3,Sheet1!$B:$F,4,FALSE)
for the price

[mshort]

Thanks brokenbiscuits, this does exactly what I wanted.

Is it possible to modify this to leave the cells blank until a selection is made from the list?

Thanks

[brokenbiscuits]

=if($B3="","",VLOOKUP($B3,Sheet1!$B:$F,3,FALSE))

[mshort]

Brilliant! Last question...

Is it possible to stop the Price cell from updating once it has been copied to sheet2? Say if the VLOOKUP was only to run once?

[brokenbiscuits]

No, unfortunately you would either need to then copy the cell, the paste specials>values, or a macro could do the job. Would you be interested in using macros?

[mshort]

Yes I would definitely be interested in using a macro, there will only be 3 people using the spreadsheet, 4 at most, so this shouldnt be a problem.

Thanks!