ExcelBanter - formula drop down list

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - formula drop down list (https://www.excelbanter.com/new-users-excel/94056-formula-drop-down-list.html)

Moh

formula drop down list

need a formula when one of the drop downs is selected, it will input a number
in another cell-- there will be about 20 items in the drop down list. so i
should get 20 different numbers it can show.

please can you help... its urgent

Max

formula drop down list

See the responses to your other, earlier post (use VLOOKUP)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Moh" wrote:
need a formula when one of the drop downs is selected, it will input a number
in another cell-- there will be about 20 items in the drop down list. so i
should get 20 different numbers it can show.

please can you help... its urgent

All times are GMT +1. The time now is 09:13 PM.