I need a function which is like vlookup in the fact that when it reads a date
in July, it then goes and finds the July cell in a range and then goes x
number of columns across to find the number. Vlookup does this only for
specific dates but I need a more generalised version which recognises that
the date is part of one of the dates in the month.
Can anyone help?