vlookup in Excel
Posted on 2015-01-29
=IFERROR(VLOOKUP(G1,'#Output'!A1:H698, 8,FALSE), "")
The link above can prevent N/A from display if vlookup can match a record. However, if it match a record with blank field, the retrieved column will be shown as 0. Is it possible to let it show blank instead of 0?