Hi there

I wonder if you could please help me with my query regarding adding a VLOOKUP to rows of data that increase and decrease in number? The scenario is this - I have a bunch of data rows that pull down from a SQL Server view. On day 1 the total number of rows might be 30, then on day 2 it might be 50 then on day 3 it might be 35 etc. I need to put a VLOOKUP in column 2 on each row. That's all pretty straightforward!

What I want to know is if it's possible to expand / reduce the cells containing the VLOOKUP depending on how many rows of data there are? So, what I'd like is something like this (i.e. I have 3 rows so the amount of VLOOKUPs in column 2 is 3).

COLUMN1 COLUMN2
ROW1 VLOOKUP
ROW2 VLOOKUP
ROW3 VLOOKUP

What I don't want is this: (i.e. there are more VLOOKUPs in column 2 than there are bits of data in column 1)
COLUMN1 COLUMN2
ROW1 VLOOKUP
ROW2 VLOOKUP
ROW3 VLOOKUP
VLOOKUP
VLOOKUP

So, in essence, I need a VLOOKUP against each row of data that exists. So, if there are 50 rows of data then I would need there to be 50 VLOOKUPs and if there's only 35 rows of data then I would need there to be 35 VLOOKUPs. However, I won't know from one day to the next how many rows will be required, so I need the amount of VLOOKUPs to be dynamic if that makes sense.

Many thanks
Jon