Asked by Jagwarman
at 2024-09-05 06:39:49
Point:500 Replies:5 POST_ID:829219USER_ID:12093
Topic:
Microsoft Excel Spreadsheet Software;;
I am using this formula that works fine until it can't find wjat it is looking for
=IF(R34="Match","",VLOOKUP(LEFT(D34,4),MatchData!L:S,8,))
but if it can't find it returns #N/A
I have tried to add ISERROR but can't get it to work.
Please help instead of #N/A I want it to say Not Found
Thanks
=IF(R34="Match","",VLOOKUP(LEFT(D34,4),MatchData!L:S,8,))
but if it can't find it returns #N/A
I have tried to add ISERROR but can't get it to work.
Please help instead of #N/A I want it to say Not Found
Thanks
