LinkBack URL
About LinkBacks
=MATCH(1,IF(E18<=J9,INDEX((E19:E4000<=J9)*(E20:E4000>=J9),0),INDEX((E18:E4000>=J9)*(E18:E4000<=J9),0)),0)
J9 = 6000
I keep getting #N/A, but with the number (6000), it works.
=MATCH(1,IF(E18<=J9,INDEX((E19:E4000<=J9)*(E20:E4000>=J9),0),INDEX((E18:E4000>=J9)*(E18:E4000<=J9),0)),0)
J9 = 6000
I keep getting #N/A, but with the number (6000), it works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks