| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
worksheets vlookups
I am trying to do a vlookup in a seperate file from the one that I have
opened. My worksheet that I am looking up has several tabs that I want to be able to vlookup on. My current Vlookup statement is =VLOOKUP(A19,'[New Monthly Invoices June 05.xls]Aug 05'!$D$1:$S$2,16) and it works fine, but only for my sheet label Aug 05, how do I look up on all worksheets within a workbook. Thanks, JJC |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Define list of worksheets | Excel Worksheet Functions | |||
| Merge Worksheets | Excel Discussion (Misc queries) | |||
| How to protect and unprotect 30 worksheets in a file every month . | Excel Worksheet Functions | |||
| Protect/unprotect all worksheets | Excel Worksheet Functions | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Linear Mode
