schreier24
New Member
- Joined
- May 9, 2014
- Messages
- 1
Hi,
What I need to do:
I have two files, File A: A master spreadsheet that is updated regularly and File B: a consumer facing spreadsheet that needs to be connected to File A and updated whenever File A is changed.
As far as I got:
I created a data connection between File A and B so that File A's data was inserted as a table in a separate sheet in File B. I then did a vlookup from the formatted consumer facing sheet in File B to the data connection table sheet. Everything worked fine until I hit "refresh all" in File B and then all my formulas returned a #N/A even though nothing in the data table that they had been referencing changed.
Is it possible to do a vlookup or any formulas off of a table that is created from a data connection?
Thanks so much!!!
What I need to do:
I have two files, File A: A master spreadsheet that is updated regularly and File B: a consumer facing spreadsheet that needs to be connected to File A and updated whenever File A is changed.
As far as I got:
I created a data connection between File A and B so that File A's data was inserted as a table in a separate sheet in File B. I then did a vlookup from the formatted consumer facing sheet in File B to the data connection table sheet. Everything worked fine until I hit "refresh all" in File B and then all my formulas returned a #N/A even though nothing in the data table that they had been referencing changed.
Is it possible to do a vlookup or any formulas off of a table that is created from a data connection?
Thanks so much!!!
