The cleanest way:
use a column ( say col V) you do not need and enter the VLOOKUP and let the NA happen
Then in your answer column enter=if(isna(V1),"",V1)
Hide col V if needed
The cleanest way:
use a column ( say col V) you do not need and enter the VLOOKUP and let the NA happen
Then in your answer column enter=if(isna(V1),"",V1)
Hide col V if needed
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks