Sean15
Well-known Member
- Joined
- Jun 25, 2005
- Messages
- 700
- Office Version
- 2010
- Platform
- Windows
@DanteAmor
Your solution here Two-Way Lookup with wildcard is great.
But if criteria is not in search range, formula returns 0%.
Can you post formula that return #N/A if criteria is not found in search range?
Regards,
Sean
Your solution here Two-Way Lookup with wildcard is great.
But if criteria is not in search range, formula returns 0%.
Can you post formula that return #N/A if criteria is not found in search range?
Regards,
Sean