Hello. I have the following formula...=VLOOKUP(C341,'[Management Book February 13.xls]Consolidation'!$A:$C,2,FALSE)/1000000, which is essentially just a standard vlookup that returns a value from a different sheet. I would like to add to this formula, so that when the lookup value is blank (it returns an #NA), it will return nothing. Thanks!!!
Bookmarks