staceydmcg
New Member
- Joined
- Oct 6, 2020
- Messages
- 2
- Office Version
- 2016
- Platform
- Windows
this is my formula and i would like it to return a blank instead of #N/A when the match isn't found.
=IF(B32*1.02>((VLOOKUP($A32,yoe,13,FALSE))),VLOOKUP($A32,yoe,13,FALSE),B32*1.02)
=IF(B32*1.02>((VLOOKUP($A32,yoe,13,FALSE))),VLOOKUP($A32,yoe,13,FALSE),B32*1.02)