Formula IF|DATE|VLookup

lwells

What formula do you use to look at a date and if it is less than a specific date to include Vlookup formula in smartsheets?

I am trying to write a formula in SS to review the Lead Create Date and if it is less than 05/01/24, than place "No Rebate" in column. If it is 05/01/24 or greater than follow VLookup formula.

Error #INCORRECT ARGUMENT SET.

The Vlookup reviews a Name in a Group and then uses a Lookup table to determine the % of Rebate.

I would appreciate any help I can get. Thank you

dojones

This works.

=IF([Lead Create Date]@row < DATE(2024, 5, 1), "No Rebate", VLOOKUP(Group@row, {72inc Range 2}, 2, false))

Your formula looks correct. Make sure when referencing the 2nd sheet that you are highlighting both columns in the lookup range. Also check column types if not working.

lwells

Thank you for your help it worked perfect. Now I have to figure out how to add additional "IF - Group column has "Overflow" go to No Rebate. Fun times. Thank you again.