I'm trying to set up a report that based on the input into one static cell on
Tab A it will search Tab B column A for the exact match and then pull in the
text from column B.

For example...

Tab A, cell H40 =12

Tab B, cell A15 =12 and cell B15 contains the text I won't pulled into Tab A
cell c62

I know this should be simple and Excel can make breakfast for you if you
know program it to do so, but I'm stumped! Any ideas?

Thanks in advance for your assistance!
--
nicole