Using vlookup function in a table

[victoria_n]

I have 'inherited' a spreadsheet that has a vlookup in a table that refers to a table in another file. It won't work. Any suggestions?.. I have tried making sure the files are both in the same e-folder on my c drive. I am lost for ideas. I am new to working in tables. would appreciate any suggestions.

 

[alansidman]

How about more details, ie. Formula you are using. Names of Workbooks, Worksheets, Table Names or Ranges holding values to lookup, etc. Help us to help you by giving us details so that we can make an educated guess and not WAGS.

 

[victoria_n]

How about more details, ie. Formula you are using. Names of Workbooks, Worksheets, Table Names or Ranges holding values to lookup, etc. Help us to help you by giving us details so that we can make an educated guess and not WAGS.

is a very simple vlookup -

=IF(ISNA(VLOOKUP([@[Lookup WR String]],'C:\1718 CONNEX RIN reporting\GL Extracts\Copy of CICW_Performance_(EEA54D) 20180605_RAW DATA.xlsx'!Table1[[#Headers],[Request Id]],1,FALSE)),"xxxx","yyyy")

I want it to return either "xxxx" or "yyyy"; currently returns all "xxxx". Interestingly if I double click in the cell and then enter, it turns all the column results to "yyyy".. doesn't make any sense at all.

 

[Aladin Akyurek]

Referencing a Table in a closed workbook even in a VLOOKUP formula won't work. Convert Table to range.