LinkBack URL
About LinkBacks
Sort you data according your category to do so select A2:F101 then press Alt->A->S->S select short by category then ok.
now in H2Formula:
=LOOKUP(2,1/($G2=$A$2:$A$101),$F$2:$F$101)
Copy down.!
Sort you data according your category to do so select A2:F101 then press Alt->A->S->S select short by category then ok.
now in H2Formula:=LOOKUP(2,1/($G2=$A$2:$A$101),$F$2:$F$101)
Copy down.!
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
Register To Reply
Bookmarks