Formula Question - Blank Needed for a Write-in Value
Hi All,
I'm trying to write a formula that will return a blank value (or empty cell) that I can add a "write-in" value - which will be different each time the blank occurs. Is there a way to do this, or does the blank that I'm asking for ultimately have to be "blank"?
=IF([Alpha-3 Code]@row = "Other", "", IFERROR(VLOOKUP([Alpha-3 Code]@row, {Country Codes Alpha-2 & Alpha-3 Range 1}, 2, false), ""))
Thanks in advance!
Answers
-
@Seatora The only way to do this, and use a column formula, is to create a second, helper column where the write in value goes. so the formula would be like this
=IF([Alpha-3 Code]@row = "Other", [helpercolumn]@row, IFERROR(VLOOKUP([Alpha-3 Code]@row, {Country Codes Alpha-2 & Alpha-3 Range 1}, 2, false), ""))
-
Hi @Seatora,
If you mean you want to go back into that cell and add in the "write-in" value, you can't do that as you would overwrite the formula (in fact, it won't let you if it's a column formula).
One work around might be to put the write-in value in a separate cell and reference that in the cases where it would have been black. It will still be blank until you add data to the other cell. Just a thought - untested.
Hope this helps,
Dave
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!