Hi ,

Can u tell me how u doing =LOOKUP(2,1/(A:A=D2),B:B); 2,1/ meaning? If u like to share... Thanks.