Lookup Value where it last appears in Column

[rhombus4]

Hi

Trying to find corresponding value in Column E for a lookup in Column A
Normally I'd use =XLOOKUP(123, A2:A20,E2:E20) which will search column A and give me the value in Column E

What if there are multiple values for the searched item in Column A. It always gives the first it finds. is it possible to get the 2nd 3rd 4th etc or in ths case the last time it appears

Expected Results are
123 Cat even though its same value for both it should be cat as its the last value
345 dog. Even if it only appears once its still classed as last value
567 giraffe as its last one to appear
678 koala as it appears last

A	B	C	D	E
123​	rndtext	rndtext	rndtext	cat
123​	rndtext	rndtext	rndtext	cat
345​	rndtext	rndtext	rndtext	dog
567​	rndtext	rndtext	rndtext	elephant
567​	rndtext	rndtext	rndtext	frog
567​	rndtext	rndtext	rndtext	giraffe
678​	rndtext	rndtext	rndtext	hedgehog
678​	rndtext	rndtext	rndtext	hedgehog
678​	rndtext	rndtext	rndtext	Koala

 

[Fluff]

How about

=XLOOKUP(123, A2:A20,E2:E20,,,-1)

 

[rhombus4]

Thanks. Not looked at the other arguments. What does the match_mode do and is it possible to look for 2nd occasion of a value or is it either 1st or last

 

[Fluff]

It's either 1st or last.