Hello,

I have been using a vlookup function that was previously suggested to me on the forum (it is below). It was being used to look at whether a date was within certain quarters that had been specified in a table (BA1:BB8). However, I would like to change it so it just looked for whether a date was inbetween date values in 2 cells (C1 and G1). Does anybody know how I could adapt the formula?

=VLOOKUP(D3,$BA$1:$BB$8,2,TRUE)

When I look on help it says that this part of the formula is for "table array", does this mean that the look up values have to be in a table (i.e. as the different quarters were before) or can i specify 2 different cells (C1 and G1) to look between?

Thanks so much,

Anna