Formula not working in excel 2007
Sir,
Namaskar! I i just installed office 2007 and some formula is not working and retruning #N/A and some formula is returning 0 value. This formula is returing #N/A =IF(ISBLANK($C1063),"",IF(VLOOKUP($C1063,Inventory _List,9,0)<0,"INVALID SALE",VLOOKUP($C1063,Inventory_List,9,0))) and this is returning 0 vlaue =IF($C1067="","",IF(ISERROR(VLOOKUP($C1067,Invento ry_List,4,FALSE)),0,VLOOKUP($C1067,Inventory_List, 4,FALSE))) what should i change in excel 2007 or should i unstall office 2007 Hope you will soon solve my problem. |
Formula not working in excel 2007
For your first formula, this portion seems suspect:
IF(VLOOKUP($C1063,Inventory_List,9,0) You are telling Excel to look 0 columns to the right. I think that number has to be at least 1. For your second formula, take a look at the new IFERROR function in Excel 2007; it will simplify your formula. Dave On Jan 2, 8:05*am, Rao Ratan Singh wrote: Sir, Namaskar! I i just installed office 2007 and some formula is not working and retruning #N/A and some formula is returning 0 value. This formula is returing #N/A =IF(ISBLANK($C1063),"",IF(VLOOKUP($C1063,Inventory _List,9,0)<0,"INVALID SALE",VLOOKUP($C1063,Inventory_List,9,0))) and this is returning 0 vlaue =IF($C1067="","",IF(ISERROR(VLOOKUP($C1067,Invento ry_List,4,FALSE)),0,VLOOK*UP($C1067,Inventory_List ,4,FALSE))) what should i change in excel 2007 or should i unstall office 2007 Hope you will soon solve my problem. |
Formula not working in excel 2007
The 9 represents the column in Inventory_list to be returned.
0 (or False) in that 4th parm means that there has to be an exact match between what's in C1063 and the first column of Inventory_List. Dave F wrote: For your first formula, this portion seems suspect: IF(VLOOKUP($C1063,Inventory_List,9,0) You are telling Excel to look 0 columns to the right. I think that number has to be at least 1. For your second formula, take a look at the new IFERROR function in Excel 2007; it will simplify your formula. Dave On Jan 2, 8:05 am, Rao Ratan Singh wrote: Sir, Namaskar! I i just installed office 2007 and some formula is not working and retruning #N/A and some formula is returning 0 value. This formula is returing #N/A =IF(ISBLANK($C1063),"",IF(VLOOKUP($C1063,Inventory _List,9,0)<0,"INVALID SALE",VLOOKUP($C1063,Inventory_List,9,0))) and this is returning 0 vlaue =IF($C1067="","",IF(ISERROR(VLOOKUP($C1067,Invento ry_List,4,FALSE)),0,VLOOK*UP($C1067,Inventory_List ,4,FALSE))) what should i change in excel 2007 or should i unstall office 2007 Hope you will soon solve my problem. -- Dave Peterson |
Formula not working in excel 2007
I'd review the notes for troubleshooting =vlookup() formulas from Debra
Dalgleish: http://contextures.com/xlFunctions02.html#Trouble Rao Ratan Singh wrote: Sir, Namaskar! I i just installed office 2007 and some formula is not working and retruning #N/A and some formula is returning 0 value. This formula is returing #N/A =IF(ISBLANK($C1063),"",IF(VLOOKUP($C1063,Inventory _List,9,0)<0,"INVALID SALE",VLOOKUP($C1063,Inventory_List,9,0))) and this is returning 0 vlaue =IF($C1067="","",IF(ISERROR(VLOOKUP($C1067,Invento ry_List,4,FALSE)),0,VLOOKUP($C1067,Inventory_List, 4,FALSE))) what should i change in excel 2007 or should i unstall office 2007 Hope you will soon solve my problem. -- Dave Peterson |
All times are GMT +1. The time now is 04:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com