Hi Zygan,

You can use a combination of INDEX() and MATCH()

Have a look at this link

http://www.mrexcel.com/tip021.shtml

Regards,
Bondi