•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
XLOOKUP in VBA is Providing Errors
I am trying to create a macro that will be able to find a cell based on the contents of two other cells and add the text from a third cell to the end of the referenced cell in question. Every time I try to run this, it throws an error, currently of Type Mismatch.
In the attached screenshot, John Smith should end up with 1 Cabernet, 2 Bottles Champagne as his text in column c.
What am I doing wrong?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel compatibility
#cloud-based spreadsheet applications
#Excel alternatives for data analysis
#real-time data collaboration
#financial modeling with spreadsheets
#real-time collaboration
#Excel alternatives
#XLOOKUP
#VBA
#Type Mismatch
#macro
#error
#cell
#text
#column
#contents
#referenced cell
#find
#screenshot