Thanks for your quick reply.
I got it working with
=VLOOKUP(A1,Sheet2!A15:B37,2)
The formula works fine, except when the lookup cell is
empty, I get #N/A. I believe it can show an empty cell
with ISBLANK...what should be the code?
I tried =IF(ISBLANK(=VLOOKUP(A1,Sheet2!A15:B37,2)) but
doesn't work.
|