Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula for comparing text in two workbooks
I have a wkbk with first names, last names, street. Another workbook has
first names, last names. I would like to compare the two and if both columns match, I need to insert the street. I have the following to tell me if there is a match: =IF(SUMPRODUCT(('[!ID.xls]all'!$B$2:$B$541=E11)*('[!ID.xls]all'!$C$2:$C$541=K11)), "Match", "Need to ID") |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) | |||
Logical Text Formula | Excel Worksheet Functions | |||
how can i merge 2 workbooks using a formula? | Excel Worksheet Functions | |||
Display numbers only, no text formula | Excel Worksheet Functions |