or try
CJ48=LOOKUP(2,1/(OFFSET($AW$47,MATCH(CI48,$AW$48:$AW$56,0),1,1,36)<>""),OFFSET($AW$47,MATCH(CI48,$AW$48:$AW$56,0),1,1,36))
Formula:
=LOOKUP(2,1/(OFFSET($AW$47,MATCH(CI48,$AW$48:$AW$56,0),1,1,36)<>""),OFFSET($AW$47,MATCH(CI48,$AW$48:$AW$56,0),1,1,36))
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks