Grabbing a value that is related to another :)

[abarth]

Hello , this is my 1st post & question , but i think it will be easy fo
you to answer
I am also new in excel (i have programmed in asp,php,sql etc but neve
in excel...i thought it would be better to look in a forum than in
book for my 'prob')

so let me explain exactly what i want to do:

Sheet 1:
i have 1 column with 10 cells (a1:a10) that have a text inside (smal
text like DVD-RW)
in the 2nd column i have 10 cells (b1:b10) with numbers
the number in each cell is related to the text in the cell next to it
for example the number in B3 cell is related to the A3 text ...

In another Sheet (2):
I want to create a drop list with the values of A1:A10 range of sheet1
This drop list will be placed on Cell C1 of sheet2
For example I choose the value of A5 in the drop list
Automaticaly i want to be stored in the next cell of sheet2 (D1) th
related value of A5 , this means the number-value of B5 of sheet1

how do i make ALL these?

sorry for my english, but i am from greece and is hard for me t
describe fine all i have in mind

thnx in advance

 

[JE McGimpsey]

One way:

Select Sheet1, A1:A10 and name it, say, "my_list" by typing the name in
the Name box at the left of the Formula bar.

Select Sheet2, cell C1, and choose Data/Validation:
Allow: List
Source: =my_list


in sheet2, cell D1, enter:

=VLOOKUP(C1,Sheet1!A:B,2,FALSE)