Hi,
I think I am complicating things but I've been trying for a while, so time to ask for help....
I have two tabs on a workbook. Data and Lookups. On the Lookups tab I am trying to look at if an employee was working in Jan 24, Feb 24 etc, then VLOOKUP a table and return a value.
Answers from my current formula are in Cells Q34:V115.
The correct answers are in Cells Q119:V120 (typed in).
The formula in Cell Q34 is
The Data Columns I am looking at are;
Does anyone have any idea how i can get this to work please?
Thanks,
James
I think I am complicating things but I've been trying for a while, so time to ask for help....
I have two tabs on a workbook. Data and Lookups. On the Lookups tab I am trying to look at if an employee was working in Jan 24, Feb 24 etc, then VLOOKUP a table and return a value.
Answers from my current formula are in Cells Q34:V115.
The correct answers are in Cells Q119:V120 (typed in).
The formula in Cell Q34 is
The Data Columns I am looking at are;
Does anyone have any idea how i can get this to work please?
Thanks,
James