| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple worksheet vlookup
Hi guys,
I have a workbook containing 46 sheets and I am trying to use VLookup to return a valiue on a summary sheet when one of the specific worksheet names is entered in cell K2 The formula I am currently trying is highlighted below however it is returning #REF! =VLOOKUP(K2,THREED('[Heart Rate.xlsx]Week 1':'[Heart Rate.xlsx]Week 46'!$D$7:$NF$74),9,0) The data to be looked up is located in a seperate workbook to the summary sheet and the workbook is called "Heart Rate". The worksheets within this workbook are labled "week 1" thorugh to "week 46". Any help would be fantastic. Many thanks in advance, Ant |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup with Multiple criteria and multiple sheets | Excel Worksheet Functions | |||
| Vlookup for multiple criteria, multiple worksheets | Excel Worksheet Functions | |||
| Trying to do Vlookup on multiple columns from different worksheet | Excel Worksheet Functions | |||
| How do I use VLOOKUP to ref multiple workbooks with multiple tabs? | Excel Discussion (Misc queries) | |||
| Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
Threaded Mode
