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?????

How to create a complicated formula
 

You have a suggestion in your other post.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Cindy" wrote in message
...
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?????