LinkBack URL
About LinkBacks
Hi,
I have the following formula. The array covers a number of rows some of which return #N/A even if I include the error.
{=IFNA(OFFSET($F$1,MATCH($B$8,$D$2:$D$9,0),,$B$6),"")}
Is it possible to get it to return an empty string?
Thanks
Hi,
I have the following formula. The array covers a number of rows some of which return #N/A even if I include the error.
{=IFNA(OFFSET($F$1,MATCH($B$8,$D$2:$D$9,0),,$B$6),"")}
Is it possible to get it to return an empty string?
Thanks
Just guess:
=IFNA(OR(ISERROR(OFFSET($F$1,MATCH($B$8,$D$2:$D$9,0),,$B$6))),"")
Note: OFFSET returns a range. ISERROR(OFFSET...) to turn error into TRUE
OR(...) returns TRUE if there is one error occur at least.
Quang PT
It occurred to me I can do an IFERROR formula in the adjacent column!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks