Formula works but returns N/A

**troysie** · 04-10-2013, 10:32 AM

this formula works but returns N/A when l2 blank. I want it to return a blank cell when l2 is blank

Please Login or Register  to view this content.

Regards Troysie

**Jonmo1** · 04-10-2013, 10:38 AM

Try

=IF(L2="","",HLOOKUP(L2,Sheet4!A2:A59,Sheet4!B2:B59,FALSE))

or to actually trap all #N/A errors (including when the value in L2 is not found in sheet 4)
=IFERROR(HLOOKUP(L2,Sheet4!A2:A59,Sheet4!B2:B59,FALSE),"")

**daddylonglegs** · 04-10-2013, 11:00 AM

Originally Posted by troysie

=HLOOKUP(L2,Sheet4!A2:A59,Sheet4!B2:B59,FALSE)

That formula doesn't make much sense to me, usually the red part will be a number, not a range ......and if you only have one column as the "lookup array" with HLOOKUP then you are actualy just comparing L2 with a single cell, Sheet4!A2 - can you explain what that formula should do?

Formula works but returns N/A

LinkBack

Thread Tools

Rate This Thread

Display

Formula works but returns N/A

Re: Formula works but returns N/A

Re: Formula works but returns N/A

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions