Hi

Try using vlookup instead
=VLOOKUP($B$3,PB!$A$1:$B$100,2,0)
Extend the value 100 in the above to account for the total number of
rows of data in PB!A:B

--
Regards

Roger Govier


"Beard" wrote in message
...
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