How to populate cells from a a list selection

[fcf]

Hi

does anyone know if you can populate cells based on a selection from a list

I want to set up a list using the SKU number

then have excel pull the rest fo the information

for example

cell c2 has the list dropdown

102774

cell c3

2.5"African violet"

cell c4

25 viol

cell c5

$0.90

cell c6

32

cell c7

00696692900010


in short the user selcets the sku from a dropdown list and all the rest of the info is auto populated


SKU Item Code Cost Pack UPC

102774, 2.5"AFRICAN VIOLET, 25VIOL, $0.90, 32, 00696692900010

 

[Faseeh]

Hi fcf,


You can use a combination of Data Validation Feature and OFFSET() to get this.


Regards,

 

[fcf]

hi Faseeh

i am really not sure what you mean, i have not used them

 

[cacos]

You can also use Index and Match very easily to return the remaining info.


Check here


http://office.microsoft.com/en-us/excel-help/match-function-HP010062414.aspx


http://office.microsoft.com/en-us/excel-help/index-function-HP010069831.aspx?CTT=3