Running a VLKKUP against an increasing / decreasing set of rows

[fuzzyjonclay]

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

 

[fuzzyjonclay]

Sorry, the title should obviously say VLOOKUP but I'm unable to edit the post for some reason.

 

[Aladin Akyurek]

What is the VLOOKUP formula you have?

 

[fuzzyjonclay]

What is the VLOOKUP formula you have?

Hi Aladin,

The formula is =VLOOKUP(A11,Sheet2!A7:B106,2,FALSE)

Best wishes
Jon

 

[Aladin Akyurek]

Does this help?

=VLOOKUP(A11,Sheet2!A:B,2,0)​