Ask Question Forum:
Model Library:2025-02-08:A.I. model is online auto reply
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by Jagwarman
at 2024-09-05 06:39:49
ModifyPoint: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
Author: Jagwarman replied at 2024-09-05 07:06:14
many thanks
Expert: DanCh99 replied at 2024-09-05 07:06:13
by the way, it's much easier for us to work on an example sheet (with no confidential data on it, of course) if you can attach them...
Expert: DanCh99 replied at 2024-09-05 07:04:40
=IF(R34="Match","",VLOOKUP(VALUE(LEFT(D34,4)),MatchData!L:S,8,FALSE))
I think you need the VALUE command to properly extract a numeric to satisfy the VLOOKUP.
I think you need the VALUE command to properly extract a numeric to satisfy the VLOOKUP.
Expert: rwniceing replied at 2024-09-05 07:04:30
=IF(R34="Match","",IF(ISERROR(VLOOKUP(LEFT(D34,4),MatchData!L:S1,8,TRUE)),"NOT FOUND",VLOOKUP(LEFT(D34,4),MatchData!L:S1,8,TRUE)))
You can try this, you need to specifiy exact match with TRUE
You can try this, you need to specifiy exact match with TRUE
Accepted Solution
Expert: Neilsr replied at 2024-09-05 06:44:01
500 points EXCELLENT
=IFERROR(IF(R34="Match","",VLOOKUP(LEFT(D34,4),MatchData!L:S,8,)),"Not Found")
