Solved: List box selection

[ads_3131]

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]

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]

THANKS! that works great!