Different outcome for drop down box variables

Originally Posted by Frankiemillion

i was wondering if i can put name into a drop down box then get different date outcomes from different names... such as if sue is selected in the drop down menu then B1(a date i insert myself + 14 days)... ive got the drop down box already and know how to get the auto date (=B1+14) just dont know how to change it for different variables in the drop down box... i hope this is a challenge to some of u lol...

Hi,
You could try a vlookup formula,
here's an example

ok another slight challenge... is there anyway to show nothing in the autodate cell until i have selected a name from the drop down box??? because atm it comes up with #N/A and would like it to show nothing untill a person has been selected

Originally Posted by Frankiemillion

ok another slight challenge... is there anyway to show nothing in the autodate cell until i have selected a name from the drop down box??? because atm it comes up with #N/A and would like it to show nothing untill a person has been selected

Try copying and pasting this in place of the original formula C1

=IF(ISNA(TEXT(B1+VLOOKUP(A1,$F$1:$G$5,2,0),"mmmm dd, yyy")),"",TEXT(B1+VLOOKUP(A1,$F$1:$G$5,2,0),"mmmm dd, yyy"))

Originally Posted by Frankiemillion

ok that didnt work... comes up with "the formula you type has an error." and has the quotation marks highlighted. so i put a space between them and then the last quotation mark is highlighted...

I just copied and pasted it again into the sheet and it worked for me, I am sure you will be able to get it, if not try this
=IF(ISERROR(TEXT(B1+VLOOKUP(A1,$F$1:$G$5,2,0),"mmmm dd, yyy")),"",TEXT(B1+VLOOKUP(A1,$F$1:$G$5,2,0),"mmmm dd, yyy"))