You want to do a match, but there are extra spaces in one set of data?
If that's what you're asking, you can use the TRIM function to remove
extra spaces before trying the match. If not, you may have to be more
precise is asking your question.

On May 16, 2:29 pm, freetry wrote:
I have a two spreadsheets with the same information and want to compare
account ID, which is on both sheets and on a match, change the information in
one field.