1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Comparing columns and extranting a value

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.

submitted by /u/Royal_Instance4497
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article
Comparing columns and extranting a value