Normally (with files residing on a normal file share) after filling out the 1st parameter ("lookup_value"), the user can select a range of columns in another worksheet to indicate the "table_array" (2nd parameter). These selected columns are then displayed
with dashed borders to indicate to the user that he has selected them. However, when trying to do this selection in Excel sheets residing in a SharePoint library, this functionality does not work. The columns are not shown in dashed borders and can also not
be selected. As a consequence the table_array cannot be created. in the VLOOKUP formula.
Does anybody know why this happens with Excel sheets on SharePoint?
Is there a known workaround or configuration that needs to take place?
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.