Exceeding the limit for Nested IFs

B

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.
 
R

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
 
B

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.
 
B

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?
 
S

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top