Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Table_Array arg for VLOOKUP

In Excel 2003, I could define the Table_Array argument for the VLOOKUP
function by selecting a second workbook after the VLOOKUP argument pulldown
was activated. I am unable to repeat this with Excel 2007... anybody know a
solution?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,344
Default Table_Array arg for VLOOKUP

Hi,

I'm not clear on your problem, I seem to be able to do what you are
describing.

Please give us a little more detail.
--
Thanks,
Shane Devenshire


"TMac71" wrote:

In Excel 2003, I could define the Table_Array argument for the VLOOKUP
function by selecting a second workbook after the VLOOKUP argument pulldown
was activated. I am unable to repeat this with Excel 2007... anybody know a
solution?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
vlookup table_array A Excel Discussion (Misc queries) 4 May 2nd 08 11:02 PM
vlookup with dynamic table_array Jim Toohey Excel Worksheet Functions 3 November 10th 06 10:46 PM
Vlookup with function in table_array JoshuaEyer Excel Worksheet Functions 2 October 15th 05 03:49 PM
VLOOKUP TABLE_ARRAY veljo Excel Worksheet Functions 6 April 1st 05 12:28 AM
vlookup template -> table_array martinbr Excel Worksheet Functions 1 November 20th 04 04:53 PM


All times are GMT +1. The time now is 03:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"