Return a Cell Address Using VLOOKUP

  • Thread starter Thread starter Augie_Roy
  • Start date Start date
A

Augie_Roy

Is it possible to return a Cell Address using VLOOKUP or is ther
another way to dynamically populate the Anchor Cell of the OFFSE
formula?

I have 3 columns of data that based on a user entry I need to sum th
last x rows to calculate a sum.

Any thoughts for a newbie?

Thanks
 
Maybe something like this

=SUM(OFFSET($D$6,MATCH(A1,$C$6:$C$200,0)-1,,3))

will find the row number counted from row 6 matched in C and sum the
3 values with the lookup cell included, so if you lookup a value in C that
is in
C13, then the formula will sum D13:D15

if you would lookup the first value using vlookup it would look like this

=VLOOKUP(A1,$C$6:$D$200,2,0)
 
Back
Top