multiple IF functions

[Luc]

Hi All,

I'm trying write an long IF formula, but excel only allows 7 (i think) If's
in a
string. What do i do if there are 10 or more IF's to choose from?

Thanks for any help,

Luc

 

[Frank Kabel]

Hi Luc
7 nested functions is the maximum in Excel. If you have so many
conditions normally a lookup table and using VLOOKUP is the better
alternative.
You may provide some more details what you're trying to achieve so we
can provide you a more specific answer

 

[Luc]

here's a little more detail about what i'm trying to do:

i have numbered clients from 1 to 11 (and this will go up as i add to the
list) and i want to be able to put in a number in one cell, so that another
cell displays information on that client....hope that makes sense!

Column A has numbers from 1 to 11
Column B has the names of the clients
Column C has the clients contact details
Column D has more ifo on the client, etc.

On a second worksheet, i want to be able to put in Number 5 and have it
return the name of client, contact details, etc.

thanks for any help!!

Luc

 

[Norman Harker]

Hi Luc!

Use a VLOOKUP approach

Name your client data table MyTable

Then on your second sheet you can use 3 formulas:

=VLOOKUP(A1,MyTable,2,FALSE)
=VLOOKUP(A1,MyTable,3,FALSE)
=VLOOKUP(A1,MyTable,4,FALSE)

This will return the data against the number in A1 from columns 2, 3
and 4 of your table.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Luc]

thanks for that Norman...but if i can be very simple here...how do i name
the table??

 

[Frank Kabel]

Hi
try the following:
- select the table
- goto 'Insert - Name - Define'
- choose a name for the selected range

 

[Luc]

that's fantastic guys! thanks very much for that!!