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,PB!B6,IF($B$3=PB!$A$7,P B!B7,IF($B$3=PB!$A$8,PB!B8))))))))

PLEASE HELP!!! THANKS.

--
Brad