View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cindy
 
Posts: n/a
Default How to create a complicated formula

I know what I want to do but I don't know how to do it.

I have a cell with a drop down list and I need the cell next to it to be
able to tell which word I pick and then enter a correct number for that
particular word.

Example

A3 - Restaurant, Mini-Warehouse, Etc
B2 - $500,000
B3 needs to say if A3 says Mini-Warehouse @ B2 equals $.22

Is this possible?????