VLookup only works on particular entries in the column being looke

B

Becky

I have a vlookup formula in spreadsheet A picking up a value in spreadsheet
B. There are 3 possible entries in the column in Spreadsheet B - N,W or C. If
spreadsheet B is not open and the links are updated in Spreadsheet A, then
only the cells with a N in are picked up, if the cell has a W or a C in it
then #N/A is shown. It only picks up the W or C if spreadsheet B is open. If
I change a W or C in spreadsheet B to a N, save it, shut B down and reopen
spreadsheet A then it now picks up the changed value.

I've checked all formats and formulas and nothing is wrong. The only thing
it doesn't like if the letters W or C in this spreadsheet.

Any suggestions on why this could happen or how to fix it are extremely
appreciated.
 
B

Becky

The formula I used was
=VLOOKUP($A8,'S:\Operations_Assembly\PUBLIC FOLDER\Working Document\[Working
Document T500.xls]Actuals Input Sheet'!$1:$22750,6,FALSE).
 
B

Becky

I have checked that. It's picking up the value to lookup ok (the leftmost
cell) as other lookups in the same row looking up different column numbers
are picking up correctly. It's only when this particular column shows a W or
a C that it doesn't work if spreadsheet B isn't open. If it's a N or the
spreadsheet is open then it works ok.

None of the data is downloaded.
 
B

Becky

Changing the value in the cell that I want to return makes it work. Changing
it to N works, changing it to W or C stops it working.
 
Top