Can vlookup also access table_arrays in other data documenst? If so whats the correct syntax to define that external table_array?
Yes, this is possible.
Step 1. say you have a table in a data document
Step 2: create a single cell that maps the entire table into a cell as an array, for example =A2:C5 here
Step 3: You will see entire table here in that cell
Step 4: Now copy the reference of that table (in my example A1) to your vlookup formula in another record.
Step 5: The VLOOKUP will work
Hope this helps.
1 Like