Excel question

[nowhere.elysium]

I've got a workbook with two sheets in it.

Sheet 1 is a customer tracking sheet, so it contains a list of purchases.
Sheet 2 is a list of commodities and prices for said purchases.

I have a data validation drop-down list in Sheet 1 that reads from sheet 2 - cell D2 in this case. I want the cell next to that (E2) to show the price from sheet 2, which is stored in a cell adjacent to the product in sheet 2.

How do I go about this? I appreciate that I'm asking the question fairly clumsily, but I'm hoping it's clear enough to make sense.
____________________
'10 SV650SF, '83 GS650GT (it lives!), Questionable DIY dash project, 3D Printer project, Lasercutter project

[The Shaggy D.A.]

VLookup should do it, got an example spreddy you could post?
____________________
Chances are quite high you are not in my Monkeysphere, and I don't care about you. Don't take it personally.
Currently : Royal Enfield 350 Meteor
Previously : CB100N > CB250RS > XJ900F > GT550 > GPZ750R/1000RX > AJS M16 > R100RT > Bullet 500 > CB500 > LS650P > Bullet Electra X & YBR125 > Bullet 350 "Superstar" & YBR125 Custom > Royal Enfield Classic 500 Despatch Limited Edition (28 of 200) & CB Two-Fifty Nighthawk > ER5

[nowhere.elysium]

I can't get Vlookup to behave itself across sheets, but I'll try to post it up in a sec.
____________________
'10 SV650SF, '83 GS650GT (it lives!), Questionable DIY dash project, 3D Printer project, Lasercutter project

[The Shaggy D.A.]

Here's a quickie - hope it attaches
____________________
Chances are quite high you are not in my Monkeysphere, and I don't care about you. Don't take it personally.
Currently : Royal Enfield 350 Meteor
Previously : CB100N > CB250RS > XJ900F > GT550 > GPZ750R/1000RX > AJS M16 > R100RT > Bullet 500 > CB500 > LS650P > Bullet Electra X & YBR125 > Bullet 350 "Superstar" & YBR125 Custom > Royal Enfield Classic 500 Despatch Limited Edition (28 of 200) & CB Two-Fifty Nighthawk > ER5

[Jefr0]

Nothing to see here
____________________
Rides: Honda XR 125 ('03) Honda CBR 600F ('91), Ducati 916 Biposto ('95)

[Aff]

Like this?

:edit: such slow.
____________________
Current Bikes:Honda 929RR Fireblade, Honda CD200 Benly (Project), Stomp Z2 140
Electric Bike Project

[nowhere.elysium]

Done, thanking you Mr. Shaggy.
____________________
'10 SV650SF, '83 GS650GT (it lives!), Questionable DIY dash project, 3D Printer project, Lasercutter project

[The Shaggy D.A.]

[nowhere.elysium]

Gotta admit, I'm now wondering if it's possible to hook Excel into AD to do a proper name lookup with, but that's a project for another day, methinks

Thanks for your help folks - you've made my life distinctly easier now
____________________
'10 SV650SF, '83 GS650GT (it lives!), Questionable DIY dash project, 3D Printer project, Lasercutter project

[The Shaggy D.A.]

[nowhere.elysium]