| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to match data of one column with other
i want to match records of my client with my own and to find difference if any
any help on subject heartly appreciated. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to match data of one column with other
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)),"Not on my list","match") Vaya con Dios, Chuck, CABGx3 "sadrukhan" wrote: i want to match records of my client with my own and to find difference if any any help on subject heartly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Retreive data from another worksheet based on multiple columns | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions | |||
Linear Mode
