redspanna
Well-known Member
- Joined
- Jul 27, 2005
- Messages
- 1,602
- Office Version
- 365
- Platform
- Windows
Hello all
I have a button which when selected executes a VLOOKUP formula.
The result from this VLOOKUP formula is then copy/pasted elsewhere in my worksheet.
I would like a Msgbox to be displayed showing an error if the results of the VLOOKUP is #N/A, in other words if the searched value can't be found ...
Help much appreciated
I have a button which when selected executes a VLOOKUP formula.
The result from this VLOOKUP formula is then copy/pasted elsewhere in my worksheet.
I would like a Msgbox to be displayed showing an error if the results of the VLOOKUP is #N/A, in other words if the searched value can't be found ...
Help much appreciated