-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Return Blank Cell Instead of N/A
- Thread starter rcirone
- Start date
dispelthemyth
Well-known Member
- Joined
- Mar 16, 2006
- Messages
- 663
- Office Version
-
- 365
- Platform
-
- Windows
Assuming you have Excel 2007 onwards
=iferror(INDEX(Data!$C$2:$C$200,MATCH($B60,Data!$D$2:$D$200,0)),"")
=iferror(INDEX(Data!$C$2:$C$200,MATCH($B60,Data!$D$2:$D$200,0)),"")
Upvote
0
