Dear sir,with best regards,i need your help to solve my problem in my sheet which contains this formula(=(LOOKUP(2;1/($O$8:$O$5000=Z15);$Q$8:$Q$5000)),when i pull it down i got (#N/A)against all blank cells,how can i get (0) or ( empty cell) instead of (#N/A).
Many thanks in advance.
Bookmarks