PDA

View Full Version : Solved: List box selection



ads_3131
03-05-2011, 05:59 AM
Hello

I have a example attached if anyone can help........../ i have some list boxes in lets say column A (using data-validation) and in column C i have desciptions..... How can i put a subject using the list box in column A to then Autofill the description in Column (C)? :S

Thanks

shrivallabha
03-05-2011, 07:15 AM
In the second column use the formula below:

=VLOOKUP(B5,$B$28:$C$31,2,0)
You can find the relevant information about this formula in Excel help if you do not know about this formula.

ads_3131
03-08-2011, 01:11 AM
THANKS! :) that works great!