mdonovan890
New Member
- Joined
- Dec 22, 2016
- Messages
- 24
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
=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
