Ask Your Question

Find a value i a column and report last value the row with that previously found value [closed]

asked 2016-06-07 10:08:01 +0200

Lasse gravatar image

updated 2020-08-03 12:53:32 +0200

Alex Kemp gravatar image


I have a worksheet with a list of sales done by my employees. The worksheet is linked to an export done by our store system which is in turn sorted using a pivot table. What i would like to do is search said pivot table for a specific value in the first column (for example employee name), then find the last cell with a number in the same row as the previously found value. That value should be pasted in a cell in a different sheet.

The sheet in which the pivot table is located is sheet2 whereas the sheet in which i want the result to be pasted is sheet1. Could this be done easily?

Thanks in advance

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-03 12:53:40.415362

1 Answer

Sort by » oldest newest most voted

answered 2016-06-08 09:04:11 +0200

pierre-yves samyn gravatar image


If I understand, you can use the GETPIVOTDATA function (see help)

Help is easier to understand with an example. I join this ExtraireDonneesPilote.ods implementing different scenarios.

Please note, some examples used for the second pivot table depend on the locale (linguistic settings): e.g.

=GETPIVOTDATA("Sum - Sales";$E$27;"Ville";"Paris")

With french UI the label is Somme - Sales and not Sum - Sales


edit flag offensive delete link more


That worked perfectly! Thanks!

Lasse gravatar imageLasse ( 2016-06-08 14:39:55 +0200 )edit

Question Tools

1 follower


Asked: 2016-06-07 10:08:01 +0200

Seen: 136 times

Last updated: Jun 08 '16