Looking up values.

[Spitfire999]

Hey everyone.

I have a quick question.
I think that I can simply do this with functions. But for this quick worksheet, I need it to be able to do the following.

When I enter a code (Evap code, Cond code) both which will be in the form AA, BB, CC, AB... and so on, I need it to go to the other page, grab a bit of the information...such as the number of tubes needed for a evaporator shell with that code, and put them into their respective cells.

It may sound a bit confusing, but its quite easy to see what I am trying to accomplish when you open up the attached workbook. (I also added some notes)

Thanks very much in advance.

-Ben-

[Spitfire999]

Please ignore this thread, I made myself think that the task was far more difficult than it actually was.

sorry for taking up forum space