Exceeding the limit for Nested IFs
 

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

Exceeding the limit for Nested IFs
 

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

Exceeding the limit for Nested IFs
 

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.

Exceeding the limit for Nested IFs
 

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

Exceeding the limit for Nested IFs
 

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


"JE McGimpsey" wrote:

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.

Exceeding the limit for Nested IFs
 

Hi Beard,

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

HTH Sige