I have two spreadsheets one which is for outputing data, and the other is to
store information. In the outputting data spreadsheet, I have a tab linked to
all the data in the store information file, so it will update the output
spreadsheet when I open the file. I am trying to do a vlookup for the data
that is in the linked tab.

The question is: does vlookup work for reference data? (i.e. the value of
cell of A1 is =E3)

I am returning a zero, every time, so I wonder if it is a format issue or
some thing else?

Send you data at , i will help you.

"angelgirlflies" wrote:

I have two spreadsheets one which is for outputing data, and the other is to
store information. In the outputting data spreadsheet, I have a tab linked to
all the data in the store information file, so it will update the output
spreadsheet when I open the file. I am trying to do a vlookup for the data
that is in the linked tab.

The question is: does vlookup work for reference data? (i.e. the value of
cell of A1 is =E3)

I am returning a zero, every time, so I wonder if it is a format issue or
some thing else?

.