excel - How to get a blank value in lookup? -
i have lookup formula use gather information different page in spreadsheet:
=(vlookup($a$3,lookup!$a$3:$ag$472,2,false)*0.01)
but if there no data in cell of lookup page, returns value of 0
. cell remain blank, same original cell.
try this:
=if(vlookup($a$3,lookup!$a$3:$ag$472,2,false)="","",vlookup($a$3,lookup!$a$3:$ag$472,2,false)*0.01)
Comments
Post a Comment