Prev: data links on subsequent worksheets
Next: How can I add the values based the color of font and the date
From: Kevin on 14 Apr 2010 14:48
I am trying to use one spreadsheet that has v-lookup formulas in it and
change the source data sheet with the current month's information. When I
change the data by paste special values, I get #n/a's on the v-lookup sheet.
Any suggestions on how to correct this problem?
--
Kevin
From: Duke Carey on 14 Apr 2010 15:14
it's likely you're getting the #n/a's because the new data doesn't have the
values you're looking up. That could be because those values simply aren't
there, or it could be that the pasted data is coming in as text where your
vlookup is expecting numbers. Copy an empty cell, then select all the values
in the first column of the lookup table, select Edit-> Paste special->Values
& Add, then click OK. That'll force Excel to convert text numerics to actual
numbers.

"Kevin" wrote:

> I am trying to use one spreadsheet that has v-lookup formulas in it and
> change the source data sheet with the current month's information. When I
> change the data by paste special values, I get #n/a's on the v-lookup sheet.
> Any suggestions on how to correct this problem?
> --
> Kevin
From: Bernard Liengme on 14 Apr 2010 15:14
Could you tell us a little about the data, the change you make and the
VLOOKUP formula?
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Kevin" <Kevin(a)discussions.microsoft.com> wrote in message
news:6296CC68-2AAA-4BCC-9FA0-BB76965FA84D(a)microsoft.com...
> I am trying to use one spreadsheet that has v-lookup formulas in it and
> change the source data sheet with the current month's information. When I
> change the data by paste special values, I get #n/a's on the v-lookup
> sheet.
> Any suggestions on how to correct this problem?
> --
> Kevin

 | 
Pages: 1
Prev: data links on subsequent worksheets
Next: How can I add the values based the color of font and the date