Exceeding the limit for Nested IFs

[Beard]

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

PLEASE HELP!!! THANKS.

 

[Roger Govier]

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

 

[JE McGimpsey]

One way:

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

 

[Beard]

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.

 

[Beard]

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?

 

[Sige]

Hi Beard,

I think this is what you are looking for:
=INDEX(PB!A1:B8;MATCH(B3;(PB!A1:A8);0);2)

HTH Sige