| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Whats wrong with this formula
Opps I mean Excel 2007
"oldjay" wrote: This workbook is used for estimating and manufacturing process control and has been used for many years. My problems have occurred since I tried to migrate to Excel 2010. I opened the workbook in 2010 and saved it as an .xls file compatible with older versions. The size of the file increased from 3.0mb to 3.6mb. It has numerous formula errors. I have deleted all data and code except 2 cells with formula errors. I have saved this workbook. It is now has 500K with only 2 cells populated. I would like someone to look at this and give me some advise on what to do. "Chip Pearson" wrote: I can't reproduce a #VALUE error (if that is what you mean by "yields value"). However, I think you might need the 4th parameter to VLOOKUP set to FALSE. E.g., ="Ext. No. "&VLOOKUP(C19,Z71:AB76,3,FALSE) If you omit the FALSE or set it to TRUE, VLOOKUP does a "closest match" lookup, and the data must be in ascending sorted order. With FALSE, you indicate to VLOOKUP that you want an exact match. The order of the data need not be sorted. Also, ensure that the cell you are looking up, C19, does not itself contain an error. Cordially, Chip Pearson Microsoft MVP 1998 - 2010 Pearson Software Consulting, LLC www.cpearson.com [email on web site] On Sun, 7 Feb 2010 07:34:01 -0800, oldjay wrote: ="Ext. No. "&VLOOKUP(C19,Z71:AB76,3)yields "Value" =VLOOKUP(C19,Z71:AB76,3) yields the correct result . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| whats wrong with this? | Excel Discussion (Misc queries) | |||
| Whats wrong with this OR formula? | Excel Worksheet Functions | |||
| whats wrong with the formula? | Excel Worksheet Functions | |||
| Whats wrong with this? | Excel Discussion (Misc queries) | |||
| Whats Wrong with this?? | Excel Worksheet Functions | |||
Hybrid Mode
