Hi,
You may also try this non array formula
=LOOKUP(2,1/($B$4:$B$7=B10),C4:C7)
--
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.