i have three columns in each spreasheet.
both have account number and serial number as the columns and description as third column
the serial number column has the same data in both columns.
the account numbers have different formats
the descriptions are completely different
i need the account numbers to transpose between the spreadsheets base on the serial number
acctno serialno description
aaa0001a 4444 orange
acctno serial no description
10001001a 4444 fruit
10001001a 4444 orange