I have a spread with sheet#1 with a whole bunch of columns, including in these columns are column "A" with check number and Column "B" with claim number. I have in sheet#2 several columns and including in those columns are column "A" with claim number and column "B" with policy. Is there a way to read the claim # from sheet#2 and find the corresponding claim # in sheet#1 and then add the policy number from sheet#2 to a column in sheet#1.
Thank you in advance
Thank you in advance