So why don't you just use a VLOOKUP formula in one of the sheets?