1. Sample file: http://www.myexpertsonline.com/freedls/pricelist.xls
2. Data Validation for the dropdown:
http://www.officearticles.com/excel/...soft_excel.htm
3. VLOOKUP to return the decimal value:
http://www.officearticles.com/excel/...soft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"DoD_au" <DoD_au.1rpyil_1120604735.0607@excelforum-nospam.com> wrote in
message news:DoD_au.1rpyil_1120604735.0607@excelforum-nospam.com...
>
> Hi guru's :o)
>
> I want to create a drop down list (with text: GBps, MBps, KBps etc) to
> change corresponding decimal value in another cell to update the entire
> spreadsheet with the new unit of measurement.
>
> I have attached an excerpt of the spreadsheet. Hopefully it will give
> you an idea of what i want to do.
>
> Thanks :o)
>
>
> +-------------------------------------------------------------------+
> |Filename: B&B_Excerpt.zip |
> |Download: http://www.excelforum.com/attachment.php?postid=3574 |
> +-------------------------------------------------------------------+
>
> --
> DoD_au
> ------------------------------------------------------------------------
> DoD_au's Profile:
http://www.excelforum.com/member.php...fo&userid=3874
> View this thread: http://www.excelforum.com/showthread...hreadid=384709
>