sounds like a simple vlookup formula???

will look at it later