I'm doing a VLOOKUP but getting the #N/A error even though I know the values
I'm looking up in another spreadsheet (spreadsheet A) are there. When I go
to spreadsheet A and double-click the cells with the values I want to show
up, the #N/A goes away and the value appears (so I know it's not a problem
with my VLOOKUP statement). Is there any way to "activate" all the values in
spreadsheet A so I don't have to double-click all the cells? Is there
another problem present that I'm overlooking?

Thanks!