ExcelBanter - lookup

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - lookup (https://www.excelbanter.com/excel-worksheet-functions/129570-lookup.html)

James

lookup

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

Rowland

lookup

=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

All times are GMT +1. The time now is 12:55 PM.