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

How do I write this cross reference formula

I have two columns of part numbers, column a is the part number I need and column b is the part number I'm given. I would like to copy and paste a list of part numbers in column c, have it check column b for any matches and return the associated part number from a into column d. Any solutions?

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

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#enterprise-level spreadsheet solutions
#Excel compatibility
#AI-driven spreadsheet solutions
#no-code spreadsheet solutions
#Excel alternatives
#data cleaning solutions
#AI formula generation techniques
#formula generator
#cross reference
#part numbers
#column a
#column b
#column c
#column d
#match
#formula