Ask Your Question
0

index match #n/a error [closed]

asked 2016-07-21 03:35:32 +0200

JG101 gravatar image

=INDEX('WRP WK1'.$O$14:$O$312,MATCH(A16&C16,'WRP WK1'.$B$14:$B$313&'WRP WK1'.$A$14:$A$313,0))

how do I fix this function to not show #n/a and to leave a blank with there is no value

thank you in advance for any help provided

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by JG101
close date 2016-07-22 14:48:39.130232

1 Answer

Sort by » oldest newest most voted
0

answered 2016-07-21 04:29:04 +0200

mark_t gravatar image

Use the IFNA function.

Example:-

=IFNA(INDEX('WRP WK1'.$O$14:$O$312,MATCH(A16&C16,'WRP WK1'.$B$14:$B$313&'WRP WK1'.$A$14:$A$313,0)),"")
edit flag offensive delete link more

Comments

PERFECT ! THANK YOU MARK

JG101 gravatar imageJG101 ( 2016-07-21 04:38:53 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2016-07-21 03:35:32 +0200

Seen: 305 times

Last updated: Jul 21 '16