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.