CODEWITHSUNDEEP
google-sheets
Max
Max

Reputation: 940

If & match function together in spreadsheets

I wrote this formula in the spreadsheet: =if(match(AR$2,$A5:$E5,0),AR$2,"")

If there is no match, it's supposed to leave the cell blank, instead it gives #N/A. but if there is a match, it gives the value. Can anybody show me how to correct this? thanks.

Upvotes: 1

Views: 86

Answers (1)

Liora Haydont
Liora Haydont

Reputation: 1283

You could use iferror

try something like:

=iferror(if(match(AR$2,$A5:$E5,0),AR$2),"")

Upvotes: 2

Related Questions