•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to Automate Value entry with matching numbers in a sheet
So here’s my help request. I have a table with a bunch of different item codes in column A. In column C I enter either an X or U next to the code after I adjust it. What I want to happen is that when I enter an X or U, that every other instance of that same code gets an X or U popping up next to it in column C. I’ve tried Vlookup, Index Match, and countifs and I can’t seem to get them to work how I want. Any insight into this, or additional information needed to find a proper formula?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#no-code spreadsheet solutions
#rows.com
#financial modeling with spreadsheets
#AI formula generation techniques
#Excel compatibility
#Excel alternatives for data analysis
#formula generator
#Excel alternatives
#Value entry
#Excel
#item codes
#Automate
#X
#U
#formula
#Vlookup
#Index Match
#countifs
#column A
#column C