Another option would be to use a combination of the INDEX and MATCH functions. If you're still not able to get to the answer, try posting at least a segment of the workbook (need a portion of both tabs).