Roger, thanks for the speedy response. Can you explain what is going on with
the function you have offered? What I want to do "in a nutshell" is....

Place the function in Cell Master!C3, reading the information in Master!B3.
If the information in Master!B3 matches the information in cell Test!A1, then
place the information in cell Test!B1 into cell Master!C3.

Does this make sense? Thanks.
--
Brad


"Roger Govier" wrote:

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