LinkBack URL
About LinkBacks
Steve's suggestion may be all you require but if you need to also match "Site 1", i.e. because you can't guarantee the row order, you could use this version
=LOOKUP(B4,INDEX(Overview!B$4:H$13,MATCH(A4,Overview!A$4:A$13,0),0),Overview!B$3:H$3)
Steve's suggestion may be all you require but if you need to also match "Site 1", i.e. because you can't guarantee the row order, you could use this version
=LOOKUP(B4,INDEX(Overview!B$4:H$13,MATCH(A4,Overview!A$4:A$13,0),0),Overview!B$3:H$3)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks