| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP Conversion from Excel 2003 to Excel 2007
I have a large table where the column A is also the lookup column.
Basically, I'm doing a moving average over column A. In excel 2003, the following works =VLOOKUP(A264-3000,A:A,1) In Excel 2007, I get #VALUE!. How can I use column A as the lookup source and the result column? For those of you interested, 3000 represents mileage (oil change increments). Thanks, Mike Ober. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Traditional-Simplified Chinese conversion in Excel 2007(Eng versio | Excel Discussion (Misc queries) | |||
| where is confirm conversion at open in Excel 2007? ('03 tools opt | Excel Discussion (Misc queries) | |||
| Excel 2007 conversion - this file contains labels in formulas | Excel Discussion (Misc queries) | |||
| Excel 2003 to 95 File format conversion | Excel Discussion (Misc queries) | |||
| Excel 97 to 2003 conversion problem | Excel Discussion (Misc queries) | |||
Threaded Mode
