Thanks for the help. One more question....here is the scenario.

What you have me will search the sheet PB! and populate the information from
Column B in sheet PB! once the search finds a match. What about populating
the information that is in column C on the sheet PB?

Does that make sense?
--
Brad


"JE McGimpsey" wrote:

One way:

=VLOOKUP(B3,PB!A:B,2,FALSE)

In article ,
"Beard" wrote:

I know there are other messages about nested ifs and the limit Excel places
(7), but none of them really apply. Here is what I need:

Here is the function I have now using the limit and using multiple sheets
(PB being the sheet I reference....I just need a way to use a function that
will get me the same results...but using more "nested ifs", if you will.
Here it is....

=IF($B$3=PB!$A$1,PB!B1,IF($B$3=PB!$A$2,PB!B2,IF($B $3=PB!$A$3,PB!B3,IF($B$3=PB!
$A$4,PB!B4,IF($B$3=PB!$A$5,PB!B5,IF($B$3=PB!$A$6,P B!B6,IF($B$3=PB!$A$7,PB!B7,I
F($B$3=PB!$A$8,PB!B8))))))))

PLEASE HELP!!! THANKS.