Snasui Excel Forum

Hi Dear
I got a problem with look up value to return number from the right.
I can use IFERROR with vlookup to achieve that.
I also need to ask for any formula else to do that?
Thanks

B9=AGGREGATE(15,6,D$2:D$5/(A$2:C$5=A9),1)

Thank you