If function?

[southernsquid]

Looking to have D1 look at C1 for a certain text such as 19-040S and fill in a date 8-May-19 in D1. I will have other options in C1 via drop down with different dates to fill in if selected. Just need the formula for 1 to start. Thx!

 

[Fluff]

Try
=IF(C1="19-040S",DATEVALUE("08/05/2019"),"")

 

[jtakw]

Hi,

Since C1 is selected from Drop Down (DV), I suggest putting your desired results in an adjacent column next to your "Source" for the DV Dropdown as shown below, then use something like a VLOOKUP:

Book1
	C	D	E	F	G
1	Other	8/11/2016		19-040S	5/8/2019
2				This	6/9/2018
3				That	7/10/2017
4				Other	8/11/2016
5
6				^^^Source for
7				C1 DV Dropdown
Sheet387

Cell Formulas
Range	Formula
D1	=VLOOKUP(C1,F1:G4,2,0)

 

[southernsquid]

Try
=IF(C1="19-040S",DATEVALUE("08/05/2019"),"")

Thanks @ Fluff. That works, I just had to switch the day and month. Thank you!!

 

[southernsquid]

Thank you, I will try that too. Appreciate it!!

 

[Fluff]

You're welcome & thanks for the feedback

 

[southernsquid]

You're welcome & thanks for the feedback

Hey quick question, if I want t continue toad variables do I put the next series in quotes like the first or do I use a comma? Example below.

=IF(C2="19-040S",DATEVALUE("05/08/2019"),"")(=IF(C2="19-050S",DATEVALUE("05/15/2019"),"")=IF(C2="19-060S",DATEVALUE("05/22/2019"),"")

 

[Fluff]

It needs to be like
=IF(C2="19-040S",DATEVALUE("05/08/2019"),IF(C2="19-050S",DATEVALUE("05/15/2019"),IF(C2="19-060S",DATEVALUE("05/22/2019"),"")))

but if you have a lot of these I'd recommend creating a lookup table & then using Vlookup, jtakw showed.

 

[southernsquid]

It needs to be like
=IF(C2="19-040S",DATEVALUE("05/08/2019"),IF(C2="19-050S",DATEVALUE("05/15/2019"),IF(C2="19-060S",DATEVALUE("05/22/2019"),"")))

but if you have a lot of these I'd recommend creating a lookup table & then using Vlookup, jtakw showed.

Ok, yes it was easier to follow @jtakw's recommendations. I have found that it was hard to coy the Vlookup to additional cells without identifying the source cells, but I will just adjust each one Thanks Guys!!

 

[Fluff]

If you use this version of jtakw' formula
=VLOOKUP(C1,F$1:G$4,2,0)
then you can simply copy the formula down