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

Please Login or Register  to view this content.

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"))