lookup

J

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,O44:p654)

Thanks


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dragging a formula down isn't working - where am I going wrong? 1
VLOOKUP & Data Validation 0
Vlookup and return sheet name also 2
Vlookup formula 1
N/A Error with VLOOKUP Formula - Excel 2007 6
Lookup Function help 1
Vlookup and Data Validation Q 2
Isblank vs CountBlank 1

Top