CHOOSE function - Possible with 100 values???
 

hi everyone. im sorry if my question is no very smart, but im not an expert
at all...
i'd like to use the choose function with 100 values, and not just 29. Is it
possible?
thanks a lot

Well.. you may also find another way to solve my problem:

i have tree tables:

the first table has 2 columns and a few rows. Int the first colum i will
instert numbers from 1 to 100, and in the second i will insert names, like
this:

N names
1 john
3 richard
6 mary
....

the second table has 2 columns. One that have numbers from 1 to 100 (row by
row) and another that has data from another formula (cont.if)

example:
N data
1 13
2 15
3 20
4 2
5 5
6 8
....

On the third table a want that names, number and data appear all togheter,
but only the ones that I inserted on table 1. So, in this case this table
would came out with this:

N names data
1 john 13
3 richard 20
6 mary 8

I CAN do this with "choose", but not with 100 values. I hope u could
understand what im trying to do! and thanks a lot!
please explain it step by step.... sorry about that...

Fernando S. Z.

CHOOSE function - Possible with 100 values???
 

I think you need to use VLOOKUP, something like

=VLOOKUP(table1number,table2range,2,false)


Charles
______________________
Decision Models
FastExcel 2.2 Beta now available
www.DecisionModels.com

"Fecozisk" wrote in message
...
hi everyone. im sorry if my question is no very smart, but im not an
expert
at all...
i'd like to use the choose function with 100 values, and not just 29. Is
it
possible?
thanks a lot

Well.. you may also find another way to solve my problem:

i have tree tables:

the first table has 2 columns and a few rows. Int the first colum i will
instert numbers from 1 to 100, and in the second i will insert names, like
this:

N names
1 john
3 richard
6 mary
...

the second table has 2 columns. One that have numbers from 1 to 100 (row
by
row) and another that has data from another formula (cont.if)

example:
N data
1 13
2 15
3 20
4 2
5 5
6 8
...

On the third table a want that names, number and data appear all togheter,
but only the ones that I inserted on table 1. So, in this case this table
would came out with this:

N names data
1 john 13
3 richard 20
6 mary 8

I CAN do this with "choose", but not with 100 values. I hope u could
understand what im trying to do! and thanks a lot!
please explain it step by step.... sorry about that...

Fernando S. Z.