I have been hunting around this forum for a while but have not found anything that works yet. I am looking for a formula to match up items in columns E and F to columns A and B. If there is not a match I would like blanks entered in column C and D if there is a match I would like E and F to be displayed in columns C and D. I am trying to sort through 5000+ lines of items to see which ones match.
Thank you.
Thank you.