 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / May 2008HOW DO I GET A CELL TO RETURN A NEIGHBORING CELL'S VALUE
this is a stupid question i know, but please help. i have 2 columns containing corresponding data, i.e. cell a6 contains the item i sell, cell b6 the price of that item. i have 148 different items, with 148 corresponding prices - in cells a6 through a154, corresponding with cells b6..b154. i want to create a drop down list in, say column d, where the contents of column a is displayed via the drop down list in each of the cells in my list in column d (cells a6..a148). what i then want is when i select, say the "doorbell", in the dropdown list of my cell d12 in column d that the price of the doorbell is automatically displayed next to d12 in e12. how do i do it? thanks. Go to Help and read up on VLOOKUP. Then come back if more help is neeeded best wishes  SignatureBernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme > this is a stupid question i know, but please help. i have 2 columns > containing corresponding data, i.e. cell a6 contains the item i sell, cell [quoted text clipped - 12 lines] > doorbell is automatically displayed next to d12 in e12. how do i do it? > thanks. been reading and trying vlookup all day. cant find my way around. > Go to Help and read up on VLOOKUP. Then come back if more help is neeeded > best wishes [quoted text clipped - 14 lines] > > doorbell is automatically displayed next to d12 in e12. how do i do it? > > thanks. Watch this 5 min video: How to setup a data validation drop down list: http://youtube.com/watch?v=t2OsWJijrOM Once you get the drop down list setup, see this for how to get the price for the product: http://contextures.com/xlFunctions02.html SignatureBiff Microsoft Excel MVP > this is a stupid question i know, but please help. i have 2 columns > containing corresponding data, i.e. cell a6 contains the item i sell, cell [quoted text clipped - 12 lines] > doorbell is automatically displayed next to d12 in e12. how do i do it? > thanks. a-bloody-mazing. cant thank you enough. now i know where to fing your other hints and tutors as well. you speaking in video's? > Watch this 5 min video: > [quoted text clipped - 23 lines] > > doorbell is automatically displayed next to d12 in e12. how do i do it? > > thanks. > this is a stupid question i know, but please help. i have 2 columns > containing corresponding data, i.e. cell a6 contains the item i sell, cell b6 [quoted text clipped - 6 lines] > doorbell is automatically displayed next to d12 in e12. how do i do it? > thanks. =VLOOKUP(D12,$A$6:$B$154,2,FALSE) Ken Johnson KEN, CAN'T THANK U ENOUGH. GOT IT RIGHT. DES > > this is a stupid question i know, but please help. i have 2 columns > > containing corresponding data, i.e. cell a6 contains the item i sell, cell b6 [quoted text clipped - 10 lines] > > Ken Johnson |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.