How to create a complicated formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?????
 
You have a suggestion in your other post.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Difficult Formula 2
Set non-continuous PrintArea via Function / Name 0
Extract Formula to Text 6
Pulling cell information from one workbook to another 3
Should I use VLOOKUP? IF? INDEX? 4
complicated if function 3
how to use if formula in list (data validation list) 1
Prob an easy one: How do i copy a formula EXACTLY as it is 9

Back
Top