Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet Reference in vlookup
I coded functionality into a master workbook to browse & attach a worksheet
from another closed workbook so I could use its data in the master spreadsheet. I use vlookup in that master workbook to pull the data from the spreadsheet I just imported. How can I set the Table Array reference in vlookup to recognize an imported worksheet named 'Summary' instead of getting the error #ref! ? (I built the spreadsheet with a summary page attached so that I could be sure my vlookups were set right but got the #ref! error when I deleted that spreadsheet and imported another one? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
update vlookup formula sheet reference for multiple sheets | Excel Worksheet Functions | |||
Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
Changing sheet reference to cell reference | Excel Worksheet Functions | |||
vlookup colums with reference to a formula from another sheet | Excel Worksheet Functions | |||
Using a cell reference of a sheet in Vlookup | Excel Worksheet Functions |