=if(iserror(LOOKUP(D17,O44:P654)),"",lookup(d17,o4 4:p654))
James wrote:
I want to use VLOOKUP to locate a value in an array – but if there is nothing in the input cell - the formula cell returns a #N/A. What can I add to the VLOOKUP formula so the cell remains blank if there is nothing in the input cell? =LOOKUP(D17,O44:P654)
Thanks
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com