I am trying to match data from two seperate spreadsheets to return a value
but the formatting of the data i need to match is not the same:

the id field in one sheet is:

0000100011634180000000265

and the data in the other set is:

01-1163418-265

these are actually the same and i would want to return the value in column N.

I was trying to use this:
=IF(ISNA(MATCH(H6,'Drop last comp report here'!$H:$H,0)),"",INDEX('Drop last
comp report here'!N:N,MATCH(H6,'Drop last comp report here'!H:$H,0),1))

but how do i acct for formatting difference?

Thanks