LinkBack URL
About LinkBacks
You can use an "array formula"
=INDEX(E1:G1,MATCH(TRUE,E2:G2<>"N/A",0))
confirmed with CTRL+SHIFT+ENTER
...or add an INDEX function and you can enter normally
=INDEX(E1:G1,MATCH(TRUE,INDEX(E2:G2<>"N/A",0),0))
You can use an "array formula"
=INDEX(E1:G1,MATCH(TRUE,E2:G2<>"N/A",0))
confirmed with CTRL+SHIFT+ENTER
...or add an INDEX function and you can enter normally
=INDEX(E1:G1,MATCH(TRUE,INDEX(E2:G2<>"N/A",0),0))
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks