Could you please provide me with some reference material as to how vertical lookup works? All of the formula fields cause me to become clueless! What are lookup values, table arrays, column index numbers, and range lookups? As for what Writeacher proposed, I am already following along with an overall awesome tutorial. I just find it lacking in its treatment of this one particular task. I do not want to have to sift through a multitude of results just to get a better grasp of what these four specific parts mean.