How to lookup value/text in the last 3 rows?

[James2376]

Hey, im looking for a way to lookup last 3 rows in a different excel sheet.
im currently using =xlookup(1;1/('[02. Daewoo.xlsx]Prod data'!$A:$A<>"");'[02. Daewoo.xlsx]Prod data'!$A:$A;;;-1) to get the last line, but how do i get the last 3?

 

[mrblister]

Try this. Modify the number at the end for what you need, currently will return the 3rd last row (-2 will return second-last row, -1 will return last row).
=INDEX('[02. Daewoo.xlsx]Prod data'!$A:$A;2+COUNTIF('[02. Daewoo.xlsx]Prod data'!$A:$A;"<>"&"")-3)

 

[Fluff]

How about

=take(filter('[02. Daewoo.xlsx]Prod data'!$A:$A,'[02. Daewoo.xlsx]Prod data'!$A:$A<>""),-3)

Although you would be better off limiting the range rather than using entire columns.