Want to see as numbers not text

  • Thread starter Thread starter chrisdtran
  • Start date Start date
C

chrisdtran

Thanks Julie
I tried that but that did not help! The problem seems to be from th
formula with the Vlookup function that looks into the empty cells an
returns the none-number values
 
Hi

sorry, missed the "obvious" ... replace the "0" in your formula with simply
0
e.g.
if(iserror(vlookup(C1,A1:B6,2,false),0,vlookup(C1,A1:B6,2,false))

Cheers
JulieD
 
Back
Top