Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can i use the IF function in a chart to choose its data series? | Charts and Charting in Excel | |||
numerical integration | Excel Discussion (Misc queries) | |||
Choose Function | Excel Discussion (Misc queries) | |||
Selecting a range of values for another function | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel |