I am bringing in values from another spreadsheet in 6 columns F3:K3:
This is the formula: =INDEX(U12GR6!$C$2:$C$100,MATCH(B3,U12GR6!$A$2:$A$100,0))
it works fine except if there is no value in the worksheet to use with the formula a zero is returned. How do I make sure that cell stays blank if there is a blank cell on the worksheet it is being exported from?
Bookmarks