Searching Between Excel Worksheets

S

schu1272

I am currently trying to search between two Excel Worksheets to matc
data that may have been entered incorrectly. How can I search partiall
between the two worksheets to find possible matches? I have a list o
about 1000 data sets that I am trying to find matches to. Any help o
searching between these two worksheets quickly? I am working withi
Excel 2000
 
J

jeff

Hi,

With all 3 files (2 to be searched, one with criteria)
open, & assuming your data is in col A1:A7, in one
search file column add this:

=IF(ISERROR(VLOOKUP(A1,[Test1.xls]Sheet1!
$A$1:$A$7,1,FALSE)),"","F1")

and the other column this:

=IF(ISERROR(VLOOKUP(A1,[Test2.xls]Sheet1!
$A$1:$A$7,1,FALSE)),"","F2")

Where there is an exact match for each file, you'll get
F1 or F2; no match, blanks.

Hope this is helpful
jeff
 
S

schu1272

What about if there are no exact matches and you are trying to fin
simliar matches..say last 4 digits
 
J

jeff

Hmm....

maybe play with this:

=IF(ISERROR(MID(A4,MAX(FIND("cf",A4,1)),2)),"",MID(A4,MAX
(FIND("cf",A4,1)),2))

it's looking for cf in cell A4. Combine bits of this
with the ealier...?


jeff
 
Top