drop down menu

  • Thread starter Thread starter trey
  • Start date Start date
T

trey

i have a validated drop down menu... what im trying to do
is make a choice on the drop down menu and grab a value
from another worksheet and place on my form...
ive been trying to use the " if " formula where my :
logical test is/are the components of my drop down ...the
value if true is the value's im trying to get and the
false " 0" if not returned--hopefully im not confusing
you and this makes sense... another question here also --
throughout my form i have other " if " commands and the
default on all of them is either false or 0...is there a
way i can have nothing in the cell; but still be able to
show the results...wondering..
thanks
trey
 
In the IF formula, you could use an empty string, instead of a zero. For
example:
=IF(Sheet2!B5=A5,"True","")
 
i tried that and it dsnt want to work... i will say that
i have 3 different worksheets im trying to draw from...
the drop down pulls the program from sheet2 and gets the
rate from sheet3 and i need to populate a cell in
sheet1... and how would i add more than 1 function to the
string...example i need to have more than 1 choice on the
menu with multiple choices for the cells... again i hope
im not confusing you...
thanks
trey
 
To populate the cell on sheet 1, you'd need a formula in the cell on
sheet 1, or use code to populate it.

Maybe you should be using a Vlookup formula, instead of an IF formula.
There's a sample file on my web site that uses Data Validation and
VLookup to complete an order form. You could use the same technique for
your worksheet:

http://www.contextures.com/excelfiles.html

Look for the heading: Order Form (DataValOrder.xls)
 
Hi Trey!

I'm back at it. Your situation is *MUCH* more complicated
than a "typical" lookup.

There are so many variables to lookup and they are all
located in different sized and configured lookup tables.

For example:

If A1 = this value, vlookup here, If A1 = this value,
vlookup and match this value in this lookup range etc,etc.

Biff
 
Back
Top