values of adjacent cells

Hi all,
This is my first post.

I have created a Pivot that is refreshed every month, adding a non-blank column at the end of the Pivot Table.
On a separate worksheet, I want every month to see the value of the cell of last non-blank column of the Pivot and of the cells in the 12 columns before the last one (i.e. the last 13 non-blank columns). So every month, this changes as there is a new "last non-blank cell".

I found how to return the value of the last non-blank cell.
What I am struggling with is to have the values of each of the 12 other cells...
I suspect this should be accomodated with INDEX and MATCH but I can't find out.

Any hint? Any help?

Thanks!

You mean you are trying to bring back an item from another column that coincides with the last entry in a separate column?

If yes,

If you are looking for a last numeric entry, in say column F and want to bring back column D items, try:

=LOOKUP(9.99999E+307,F:F,D:D)

if it is text entries in column F, then

=LOOKUP(REPT("z",255),F:F,D:D)

Can you show a picture of the pivot table..

or better post a sample workbook showing what you mean? Finding it hard to visualize....

How about in F7

=INDEX(B2:H2,Match(9.9999999e+307,B2:H2))

in E7:

=INDEX(B2:H2,Match(9.9999999e+307,B2:H2)-1)

in D7:


=INDEX(B2:H2,Match(9.9999999e+307,B2:H2)-2)