| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HOW DO I GET A CELL TO RETURN A NEIGHBORING CELL'S VALUE
Go to Help and read up on VLOOKUP. Then come back if more help is neeeded
best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "des-sa" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HOW DO I GET A CELL TO RETURN A NEIGHBORING CELL'S VALUE
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 -- Biff Microsoft Excel MVP "des-sa" wrote in message ... 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HOW DO I GET A CELL TO RETURN A NEIGHBORING CELL'S VALUE
been reading and trying vlookup all day. cant find my way around.
"Bernard Liengme" wrote: Go to Help and read up on VLOOKUP. Then come back if more help is neeeded best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "des-sa" wrote in message ... 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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HOW DO I GET A CELL TO RETURN A NEIGHBORING CELL'S VALUE
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? "T. Valko" wrote: 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 -- Biff Microsoft Excel MVP "des-sa" wrote in message ... 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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HOW DO I GET A CELL TO RETURN A NEIGHBORING CELL'S VALUE
On May 7, 7:22 am, des-sa wrote:
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. =VLOOKUP(D12,$A$6:$B$154,2,FALSE) Ken Johnson |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HOW DO I GET A CELL TO RETURN A NEIGHBORING CELL'S VALUE
KEN,
CAN'T THANK U ENOUGH. GOT IT RIGHT. DES "Ken Johnson" wrote: On May 7, 7:22 am, des-sa wrote: 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. =VLOOKUP(D12,$A$6:$B$154,2,FALSE) Ken Johnson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup part of a cell's contents and return value of entire cell | Excel Discussion (Misc queries) | |||
| using a cell's reference to return a value. | Excel Worksheet Functions | |||
| Find and Replace based on neighboring cells? | Excel Discussion (Misc queries) | |||
| CHANGE ONE CELL'S VALUE AND GET THE SAME RETURN - SOME HELP PLEASE | Excel Discussion (Misc queries) | |||
| find instances & report neighboring values | Excel Discussion (Misc queries) | |||
Linear Mode
