LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 31
Default Smart VLookup...

Thanks Tushar for your response.
If I go to Names I will find "Ribbon" is sitting there very happy doing
what I told it to do. Mainly waiting for the "Indirect" in the column B
validation to do the redirection. Let us say "Ribbon" NAME represent
Range (E1:E5) The specs for Ribbon.

Now you are asking me to Name another Range this time a Table say
Range (F1:G5) with the SAME name "Ribbon"

From XL point of view both are ranges one column the other a table.


Range(E1:E5) will contain {20cm,30cm,40cm etc)
Range (F1:G5) will contain {20cm,10,30cm,20,40cm,40..etc)

Will XL be confused ? I will go to the drawing board and "I will be
back"....



 
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
reinstate smart tag Phippsy Excel Discussion (Misc queries) 0 May 18th 09 10:33 AM
make VLINKUP like vlookup; smart hyperlink by data value wizard61 Excel Worksheet Functions 3 May 16th 08 04:13 PM
Invest smart Mr. Buck Excel Worksheet Functions 0 February 1st 08 04:09 AM
Invest smart Mr. Buck Excel Discussion (Misc queries) 0 February 1st 08 04:09 AM
Invest smart Mr. Buck Charts and Charting in Excel 0 February 1st 08 04:09 AM


All times are GMT +1. The time now is 10:29 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"