Return a Cell Address Using VLOOKUP

[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

 

[Peo Sjoblom]

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 D1315

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

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

 

[Augie_Roy]

Peo,

thank you very much...Match was the magic bullet!

Thanks again,
Mat