Chip Pearson has a section on this Webpage on 'Arbitrary Lookups'
that details how to do this with formulas.
http://www.cpearson.com/excel/lookups.htm
HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------
I'm using VLOOKUP function to get some values from a range. The problem is
if source range has more than one record for the condition, VLOOKUP always
gets first occurance. Is there anyway to get second or third occurance of
lookup value.
Thanks in advance
Haldun