I've tried searching past threads and I can't find a solution to my issue.
When I input a number in C18, I use VLOOKUP to return data into cell C23. Nice and simple and it works every time.
I got thrown a kink and I can't figure out how to fix it. Now the value in cell C18 (just numbers 1-4) must be compared against a previously inputted birthdate (age value) to determine what array to use for the VLOOKUP.
Right now, the formula in C23 reads, =LOOKUP(C18,'Formula Data - Do Not Edit'!A1:A4,'Formula Data - Do Not Edit'!B1:B4) -a nice and simple VLOOKUP that returns a consistent value. This is the formula that needs to be changed to account for the birthdate value being < or > 18 years of age.
Cell F6 contains the birthdate needed to determine what array to use for the VLOOKUP.
I've added a =DATEDIF function in cell F7 to determine if the birthdate is < or > 18 years of age. formula reads =DATEDIF(F6,TODAY(),"y")
Now, when I input a birthdate in F7, cell F8 provides a value (number of years)
I'm wondering how to use the value from F8 to determine what array to use in the VLOOKUP function for cell C23.
If F8>18 then i need to use one set of values in my VLOOKUP. If F8<18 then I need to use a different set of values.
I hope someone can help with this.