| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
referencing data to a table
I have a table reflecting how many members of staff are required per 450
customers. The first column therefore contains 450, 900, 1350, 1800 etc. Adjacent each customer break is the number of staff required, 10, 20, 30, 40 etc. I want to create an equation which looks at a separate cell containing a random number, reference this to the customer table and tell me how many members of staff are required. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivit table- cell on spread sheet referencing pivot table field | Charts and Charting in Excel | |||
| referencing data from a table | Excel Worksheet Functions | |||
| Referencing Data in a Pivot table. More Excel 2003 misery | Excel Worksheet Functions | |||
| Non-Static table/sheet referencing | Excel Worksheet Functions | |||
| formulas referencing pivot table cells | Excel Worksheet Functions | |||
Threaded Mode
