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

Tagged with

#AI formula generation techniques
#Excel compatibility
#Excel alternatives for data analysis
#formula generator
#Excel alternatives
#rows.com
#large dataset processing
#financial modeling with spreadsheets
#Excel
#formula
#columns
#items
#values
#column A
#column B
#column C
#column D
#compare
#matching
#list