•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Find Value to the Left
Is there a formula that will look up a value in a row and return the value to the left. The value to find is in a different column on each row. And if that value isn't in the row then return itself. I’m familiar with Xlookup but that doesn't work because the value is in different locations depending on the row. I've tried If statements, but I'm stuck on pulling the value to the left. Thank you.
Here's an example of the data. Actual data is about 3,500 rows.
THANK YOU SO MUCH!! IT worked. I really appreciate it.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#row zero
#Excel alternatives for data analysis
#rows.com
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#AI formula generation techniques
#Excel compatibility
#financial modeling with spreadsheets
#lookup
#value
#row
#return
#column
#Xlookup
#data
#If statements
#left