| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple column comparison on 2 worksheets
Ok I have sort of solved this problem and thought I would share the
love so to speak. What I did eventually was merge the 2 datain the columns in worksheet1 in the next column using something like =A2&" "&B2 if you don't want spaces use =A2&B2 I did the same on the worksheet two and then used this formula to look for duplicates =IF(ISNA(VLOOKUP(C2,Sheet4!$C$2:$C$14,1,0)),"no match", "match") hope this helps others. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using multiple criterie in one column to sum another column | Excel Discussion (Misc queries) | |||
| Multiple columns of data into one long column | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Multiple Functions In One Column | Excel Worksheet Functions | |||
| Stack multiple columns into one column... is there an easy way? | Excel Discussion (Misc queries) | |||
Threaded Mode
