HOW DO I GET A CELL TO RETURN A NEIGHBORING CELL'S VALUE

D

des-sa

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.
 
B

Bernard Liengme

Go to Help and read up on VLOOKUP. Then come back if more help is neeeded
best wishes
 
D

des-sa

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?
 
K

Ken Johnson

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.
Click to expand...

=VLOOKUP(D12,$A$6:$B$154,2,FALSE)

Ken Johnson
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

With F1 value, look at A, if match or partial match return B 5
Selecting a diff. worksheet but same cell references using Validat 1
using a cell's reference to return a value. 3
resettable, over-ridable, default cell values 0
formula to make the value in a cell, to a row in a sum function 5
How to use offset for specific value? 1
compare and return a value from another worksheet 3
Excel display two dates in one cell - excel 2010 2

Top