VLOOKUP/INDIRECT Formula

[mdonovan890]

I have a VLOOKUP formula that I am currently using

=VLOOKUP(B1986,'QC T4 BOD'!$A$373:$D$517,4,0)

What I am trying to do is avoid having to manually change the $373: $517 part of the formula every time I drag the formula down


The start and end refers to the cell address, I would like to use an VLOOKUP/INDIRECT formula but I am not sure how to apply it here

 

[Gerald Higgins]

Perhaps something like this . . .

=vlookup(B1964,indirect("'QC T4 BOD'!$A$"&B3):indirect("'QC T4 BOD'!$D$&C3),4,0)

Where B3 holds the value 20, and C3 holds the value 46.

BUT, depending on how your data is set up (which we can't see), there may be better ways of accomplishing this.

 

[mdonovan890]

This is where the data needs to be in G under project

This is the table where I am pulling the data from

 

[Gerald Higgins]

I don't understand what you are saying in post #3.

If you have posted pictures of your data, I can't see them.