this formula works but returns N/A when l2 blank. I want it to return a blank cell when l2 is blank
=HLOOKUP(L2,Sheet4!A2:A59,Sheet4!B2:B59,FALSE)
Regards Troysie