gymwrecker
Active Member
- Joined
- Apr 24, 2002
- Messages
- 390
- Office Version
- 365
- Platform
- Windows
- MacOS
The below formula in B2 is returning #N/A when A2 is blank; how can I remove #N/A so when there's no entry in A2 B2 is simply blank?
=INDEX($L$1:$L$90,MATCH(A2,$M$1:$M$90,0))
=INDEX($L$1:$L$90,MATCH(A2,$M$1:$M$90,0))