Is it possible to have VLOOKUP substitute the returned #VALUE! with a custom value, say a text string that says 'Not Available'
Basically I have a pricing tool that I perform a VLOOKUP on and if there is no price against an item, the result is #VALUE! but I want this to be the defined text I choose. Perhaps to complicate matters, the cells are formatted as Accounting with 2 decimal places, because these are prices.
Is this possible?
Basically I have a pricing tool that I perform a VLOOKUP on and if there is no price against an item, the result is #VALUE! but I want this to be the defined text I choose. Perhaps to complicate matters, the cells are formatted as Accounting with 2 decimal places, because these are prices.
Is this possible?