For Example:If cell A1 contains the letter A, B or C randomly in it, and in cell B1, lookup A1 (doesn't matter where). If cell A1 DOESN'T contain the letter A, B or C in it, I want B1 to show up blank.At the moment, the cell only shows up as #N/A when it can't find the value it's looking for.Cell A1 would have different values in it randomly (that's why I'm using lookup A1), I need to find a way to make B1 show up blank when there are NO values in A1.
How to get a cell to show blank if it cannot lookup the search key?
google spreadsheets
To suppress error messages from a command, wrap it in iferror: =iferror(vlookup(...))Generally, iferror may have a 2nd argument, custom error text. But if there is none, the cell is left blank in case of error.