| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Formula checking multiple worksheets
I have been tasked with streamlining a spreadsheet used at work. It previously had 28 worksheets A sheet for each month of the year to list occurences An audit sheet for each month and A couple of statistc sheets. The monthly sheets list events numerically although the numbers are not consecutive. I want to only have one audit worksheet which will search the monthly sheets looking for the event that is numbered in cell C10. The previous formula was =if(isblank(c10),"",vlookup('Jan'!a2:t999,2,false) ). How can I adapt this to look up all the monthly worksheets to find the event number? There are a number of formula in the audit sheet which will read further information in the same row. Any assistance is greatly appreciated. stm -- sonic-the-mouse |
|
#2
|
|||
|
|||
|
Hi!
It's not clear what you want. Do you want to lookup a value that is on each sheet or do you want to lookup a value that may be on any sheet? Biff "sonic-the-mouse" wrote in message ... I have been tasked with streamlining a spreadsheet used at work. It previously had 28 worksheets A sheet for each month of the year to list occurences An audit sheet for each month and A couple of statistc sheets. The monthly sheets list events numerically although the numbers are not consecutive. I want to only have one audit worksheet which will search the monthly sheets looking for the event that is numbered in cell C10. The previous formula was =if(isblank(c10),"",vlookup('Jan'!a2:t999,2,false) ). How can I adapt this to look up all the monthly worksheets to find the event number? There are a number of formula in the audit sheet which will read further information in the same row. Any assistance is greatly appreciated. stm -- sonic-the-mouse |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Print all charts in a workbook (multiple worksheets) | Charts and Charting in Excel | |||
| how to create a multiple conditional formula | Excel Discussion (Misc queries) | |||
| Extracting data from multiple worksheets into a list | Excel Worksheet Functions | |||
| adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions | |||
| Excel should let me refer to the same formula on multiple sheets | Excel Worksheet Functions | |||
Hybrid Mode
