Hooah_Bath
New Member
- Joined
- Dec 22, 2021
- Messages
- 3
- Office Version
- 2016
Hello. I created a VLOOKUP to find matches between 2 sheets in my workbook. For the cells without a match, it returned #N/A. I now need to get a formula to return these in another cell. I was trying something like this,
IF(A2="#N/A", Declined!B2, "Good") but I keep getting #N/A. Any help is greatly appreciated.
IF(A2="#N/A", Declined!B2, "Good") but I keep getting #N/A. Any help is greatly appreciated.