https://ccm.net/forum/affich-1028579-compare-values-in-two-columns-and-return-the-value-from-third
Hello, I have a table containing three columns. Column A shows the status of a product, "To Review", "Under Review", "Review Completed" Column B shows the date...
two columnscomparevaluesreturn
https://ccm.net/forum/affich-240642-how-to-compare-two-columns-in-two-worksheets
Best answer: Create a new column for the results wherever you want. Use vlookup - =VLOOKUP(A19,E19:F31,2,FALSE) then copy down to all the appropriate cells....
compare two columnsexcel forumworksheets