•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Comparing columns and extranting a value
Our take
If you’re new to Excel and looking to compare values across columns, we can help you simplify the process. You have items listed in column A and their corresponding values in column B. In column C, you’ll find a shorter list of items from column A. The goal is to create a formula that checks for matches between columns A and C, and if they align, it will pull the respective value from column B into column D.
I need help (I’m very new to Excel). I need a formula to help me with this: I have a large list of items in column A and corresponding values in column B. Now, in column C, I have a short list that is included in column A. I need a formula to compare columns A and C, and if the values match, then write in column D the corresponding value from column B.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience