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"....
|