match one sheet to another

Hi,

It's not clear exactly what you want.
1. By 'fields' do you mean individual cells or ranges of cells?
2. If cells are you wanting to compare one cell with another?
3. If so is the comparison from a single cell to any other cell in the second sheet or a one for one comparison. e.g should A1 in sheet 1 be compared with A1 in the other or maybe some other single cell, or should A1 be compared with any cell in sheet 2?
4. What exactly do you mean by 'search'. Do you mean identify differences?

Please clarify and no doubt we can comment.

Regards