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)