IF Statements for Dates with VLOOKUP and Concatenate

[ssmith3156]

I am still a newbie to most Excel functions. I have created a workbook with IF Statements, VLOOKUPs, Concatenates, and VBA Codes. However, due to an annual rate increase, I need to create a complex IF Statement for just this month and I can't quite wrap my head around how to do it. Currently the IF Statement seen below is in the Rate column and it is Looking up the Concatenate column, then pulling data from the ClassRate table in the Cost Type Summary sheet (1st table in second screenshot). I need it to continue pulling data from that table IF the date in the Date column on the first sheet is before 06/01/2023. If it is 06/01/2023 or later, I need it to pull the data from the ClassRateNew table (2nd table in second screenshot). Any help would be greatly appreciated!

 

[Tetra201]

Two options for you to consider:

=IFERROR(VLOOKUP(your_lookup_value,'COST TYPE SUMMARY'!$G$3:$K$106,IF(your_date_value<DATE(2023,6,1),2,5),FALSE),"0.00")
=IFERROR(VLOOKUP(your_lookup_value,CHOOSE(IF(your_date_value<DATE(2023,6,1),1,2),'COST TYPE SUMMARY'!$G$3:$H$106,'COST TYPE SUMMARY'!$J$3:$K$106),2,FALSE),"0.00")

 

[ssmith3156]

@Tetra201 I tried the second option and it worked perfectly. Thank you so much!

 

[Tetra201]

Glad to have helped.