| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help badly
I am working on a MAC in excel and need to create reports for my client that
will generate from excel file that he currently has. I tried to use the look up function the problem is that this function will only search the first two columns. I need to know a formulation that will poplulate a cell based on a letter or number value to form addtional reporting for this client. For example a 8 column sheet with 30 rows of repeated info will popluate a 3 row to column shorter reports to be broken down by location. I know this sounds confussing but some one help me. Please! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help badly
Hi,
If you post an example may be we can help you. Thanks, -- Farhad Hodjat "TheWiz?" wrote: I am working on a MAC in excel and need to create reports for my client that will generate from excel file that he currently has. I tried to use the look up function the problem is that this function will only search the first two columns. I need to know a formulation that will poplulate a cell based on a letter or number value to form addtional reporting for this client. For example a 8 column sheet with 30 rows of repeated info will popluate a 3 row to column shorter reports to be broken down by location. I know this sounds confussing but some one help me. Please! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help badly
A lookup function can get data from any number of columns - it all
depends on how wide you set your table. Give us a few more details, including a copy of what you have tried to use, then we might have a better chance to help you. Pete On Oct 9, 8:28 pm, TheWiz? wrote: I am working on a MAC in excel and need to create reports for my client that will generate from excel file that he currently has. I tried to use the look up function the problem is that this function will only search the first two columns. I need to know a formulation that will poplulate a cell based on a letter or number value to form addtional reporting for this client. For example a 8 column sheet with 30 rows of repeated info will popluate a 3 row to column shorter reports to be broken down by location. I know this sounds confussing but some one help me. Please! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| i have an excel file which i badly need for my project. the probl | Excel Discussion (Misc queries) | |||
| Need Help Badly! | Excel Worksheet Functions | |||
| VBA coding needed badly | New Users to Excel | |||
| Index Match Help Needed Badly | Excel Discussion (Misc queries) | |||
| Badly need help to put four categories in one pie chart | Charts and Charting in Excel | |||
Linear Mode
