Hi,

This array formula (Ctrl+Shift+Enter) will return the value against the last
occurrence of One. B10 contains One. I have assumed that the data is in
range B4:C7

=INDEX($B$4:$C$7,1*MAX(($B$4:$B$7=B10)*(ROW($B$4:$ B$7)-ROW($B$3))),2)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"houAstros1989" wrote in message
...
A B
ONE 1
TWO 2
THREE 3
ONE 4


Is there a way I can use the offset to look up a duplicate reference? To
where I ref ONE and come up with 4.