Hello,
My subject line is simple but the real difficulty is trying to find the amount from the same policy, but the other sheet has a combination of different amounts. It may amount to the original amount being searched or it may not. Both sheets has the policy number column A, different amounts on column B, and date on column C. I am creating the results on column D(sheet1) to match the amount from sheet 2, which has a variety of amounts that can equal to the amount on sheet 1, but it may not. If the correct amount is found, it corresponds with the date, but the date is not important, matching the right amount with the policy number is important. Please help.
My subject line is simple but the real difficulty is trying to find the amount from the same policy, but the other sheet has a combination of different amounts. It may amount to the original amount being searched or it may not. Both sheets has the policy number column A, different amounts on column B, and date on column C. I am creating the results on column D(sheet1) to match the amount from sheet 2, which has a variety of amounts that can equal to the amount on sheet 1, but it may not. If the correct amount is found, it corresponds with the date, but the date is not important, matching the right amount with the policy number is important. Please help.