close
i want to match records of my client with my own and to find difference if any
any help on subject heartly appreciated.
With your client's list in column A of Sheet1, and your list in column A of
Sheet2, put this formula in B1 of Sheet1 and copy down........
=IF(ISNA(VLOOKUP(A1,Sheet2!A:A,1,FALSE)),quot;Not on my listquot;,quot;matchquot;)
Vaya con Dios,
Chuck, CABGx3
quot;sadrukhanquot; wrote:
gt; i want to match records of my client with my own and to find difference if any
gt; any help on subject heartly appreciated.
全站熱搜
留言列表
