0
I have a projetct requesting the last and the second last values from another sheets, so far I got the last value from this index funcion bellow (as an invese vlookup), but I still couldnt get the second last.
English: =IFERROR(INDEX('E30'!$A:$H, MAX(FILTER(ROW('E30'!$C:$C), 'E30'!$C:$C=C$1)),1),0)
(Formula translated from portuguese:) =SEERRO(ÍNDICE('E30'!$A:$H; MÁXIMO(FILTER(LIN('E30'!$C:$C); 'E30'!$C:$C=C$1));1);0)
Your help will be very appreciated
Guilherme Lazzari
Posted 2019-09-09T00:03:28.060
Reputation: 1
Welcome to Super User. Google Sheets is actually off-topic on this site. It's on-topic at our sister site {Web Applications](https://webapps.stackexchange.com/). Several of use have already voted to migrate this for you. Hopefully a few more people will spot it and complete the action. Note, though, that this will be easier for people to answer if you edit in some context. What is actually in the referenced cells? What does the data look like (add a screenshot)? use the sample data to add an example of what you expect to happen and what the formula is doing.
– fixer1234 – 2019-09-10T02:09:25.967