| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP stops working with pasted values
I have the following formula in Excel 2000, which normally works fine:-
=VLOOKUP(E2,$U$2:$V$24,2,FALSE) I have a long list of values in column E with a matching formula in column F to return a category. Every month I get a new set of values in column E, which I would like to copy and paste from an external source (previous version of Excel spreadsheet). When I do a Paste or Paste Special Values, the VLOOKUP formula returns #N/A. If I overtype the pasted value with the number shown, the formula works again. I have tried using INDEX and MATCH instead of VLOOKUP and I get the same problem. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup with a range of values | Excel Discussion (Misc queries) | |||
| use vlookup or other to find the nearest values (<) or interpola | Excel Worksheet Functions | |||
| How can I use the vlookup function to return a sum of the values? | Excel Discussion (Misc queries) | |||
| vlookup to see 2 values? | Excel Worksheet Functions | |||
| VLOOKUP not working | Excel Worksheet Functions | |||
Threaded Mode
