Prev: Nested If StatementsNext: Sum with 2 if's From: PAL on 6 May 2010 16:24 Can someone advise why this formula returns a "0" and not a blank? =IF(ISERROR(VLOOKUP(A2,Rawdata,13,FALSE)),"",VLOOKUP(A2,Rawdata,13,FALSE)) Thanks. From: Bernard Liengme on 6 May 2010 16:45 Gives a blank for me Maybe column 13 of Rawdata is empty best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "PAL" wrote in message news:548687C2-6549-4F10-9196-D56A3FA20762(a)microsoft.com...> Can someone advise why this formula returns a "0" and not a blank? > > =IF(ISERROR(VLOOKUP(A2,Rawdata,13,FALSE)),"",VLOOKUP(A2,Rawdata,13,FALSE)) > > Thanks. From: Fred Smith on 6 May 2010 19:13 Because column 13 of Rawdata, row that has A2 in it, is zero or blank. Regards, Fred "PAL" wrote in message news:548687C2-6549-4F10-9196-D56A3FA20762(a)microsoft.com...> Can someone advise why this formula returns a "0" and not a blank? > > =IF(ISERROR(VLOOKUP(A2,Rawdata,13,FALSE)),"",VLOOKUP(A2,Rawdata,13,FALSE)) > > Thanks. From: Satti Charvak on 7 May 2010 03:28 change the formula to =IF(ISERROR(VLOOKUP(A2,rawdata,13,FALSE)),"",TEXT(VLOOKUP(A2,rawdata,13,FALSE),"")) basically when the formula is true it i" s returning an integer value from the "rawdata" range. also you can try changing the cell format to general also. -- Kind Regards, Satti Charvak Only an Excel Enthusiast "PAL" wrote: > Can someone advise why this formula returns a "0" and not a blank? > > =IF(ISERROR(VLOOKUP(A2,Rawdata,13,FALSE)),"",VLOOKUP(A2,Rawdata,13,FALSE)) > > Thanks.  |  Pages: 1 Prev: Nested If StatementsNext: Sum with 2 if's