| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I Need An Argument
I forgot to mention the colum range is c7:c46
-- Regards, **newdeas**<< "newdeas" wrote: I'm trying to get information from the same colums located on multiple (40)worksheets. I've adjusted the below formula many times using the =if, and & or but I'm getting "value", "non bowler", or it's skipping some of cell contents(see below): =IF(Sheet1!C7="non bowler",'Sheet1 (2)'!C7,Sheet1!C7) I'm stuck! Can anyone help me out with this one? -- Regards, **newdeas**<< |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I Need An Argument
This is pretty incomprehensible, but if I can guess: try the INDIRECT function.
-- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "newdeas" wrote: I forgot to mention the colum range is c7:c46 -- Regards, **newdeas**<< "newdeas" wrote: I'm trying to get information from the same colums located on multiple (40)worksheets. I've adjusted the below formula many times using the =if, and & or but I'm getting "value", "non bowler", or it's skipping some of cell contents(see below): =IF(Sheet1!C7="non bowler",'Sheet1 (2)'!C7,Sheet1!C7) I'm stuck! Can anyone help me out with this one? -- Regards, **newdeas**<< |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I use the argument: - IF, AND, THEN, ElSE | New Users to Excel | |||
| what is an argument? | Excel Discussion (Misc queries) | |||
| if argument? | Excel Discussion (Misc queries) | |||
| One more Argument. | Excel Worksheet Functions | |||
| IF THEN argument | Excel Discussion (Misc queries) | |||
Hybrid Mode
