this formula works but returns N/A when l2 blank. I want it to return a blank cell when l2 is blank
Regards Troysie![]()
=HLOOKUP(L2,Sheet4!A2:A59,Sheet4!B2:B59,FALSE)
this formula works but returns N/A when l2 blank. I want it to return a blank cell when l2 is blank
Regards Troysie![]()
=HLOOKUP(L2,Sheet4!A2:A59,Sheet4!B2:B59,FALSE)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks