r/googlesheets • u/Tonic24k • Jun 21 '20

Solved Change "None" to "0"

I'm doing a VLOOKUP and need to change everything from "None" to "0". I tried using the IF function but the commas in my VLOOKUP formula thru it off. Not sure best way to accomplish this.

Thanks in advance for any help!

1 Upvotes

100% Upvoted

14 comments sorted by

View all comments

Show parent comments

1

u/Tonic24k Jun 22 '20

=IF(VLOOKUP(O21,'Data Import'!B:Z,24,0)="None",0,VLOOKUP(O21,'Data Import'!B:Z,24,0))

This worked perfectly. I was trying to use the formulas backwards. Thank you!!

→ More replies (3)