If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Changing Source Data using V-lookup
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 |
#2
|
|||
|
|||
Changing Source Data using V-lookup
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 |
#3
|
|||
|
|||
Changing Source Data using V-lookup
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" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|