•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