LinkBack URL
About LinkBacks
Here's one option......
Try this array formula in sheet1 B2
=INDEX(sheet2!B2:B100,MATCH(MIN(IF(sheet2!A2:A100>=A2,sheet2!A2:A100)),sheet2!A2:A100,0))
confirmed with CTRL+SHIFT+ENTER
Here's one option......
Try this array formula in sheet1 B2
=INDEX(sheet2!B2:B100,MATCH(MIN(IF(sheet2!A2:A100>=A2,sheet2!A2:A100)),sheet2!A2:A100,0))
confirmed with CTRL+SHIFT+ENTER
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks