lookup

[James]

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,O44654)

Thanks


EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

 

[Rowland]

=if(iserror(LOOKUP(D17,O44654)),"",lookup(d17,o44654))