Vlookup error
Solved/Closed
Related:
- Vlookup error
- Network error occurred - Guide
- Cmos checksum error - Guide
- Bios rom checksum error - Guide
- Nvlddmkm.sys error windows 11 - Guide
- Error code: 230000 ✓ - Internet & Social Networks Forum
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 27, 2010 at 01:30 PM
Jun 27, 2010 at 01:30 PM
You need to add the fourth parameter "true or false"
VLOOKUP("EDI",A2:B13,2, FALSE)
better would be
=IF(ISERROR(VLOOKUP("EDI",A2:B13,2, FALSE)), "", VLOOKUP("EDI",A2:B13,2, FALSE)
VLOOKUP("EDI",A2:B13,2, FALSE)
better would be
=IF(ISERROR(VLOOKUP("EDI",A2:B13,2, FALSE)), "", VLOOKUP("EDI",A2:B13,2, FALSE)