LinkBack URL
About LinkBacks
Try it in BW7, copy accross and down
=VLOOKUP($BV7,$A$7:$BJ$30,MATCH(INDIRECT(ADDRESS(5,61+COLUMNS($A:A)*2)),$2:$2,0),0)
Try it in BW7, copy accross and down
=VLOOKUP($BV7,$A$7:$BJ$30,MATCH(INDIRECT(ADDRESS(5,61+COLUMNS($A:A)*2)),$2:$2,0),0)
Quang PT
Hi Bebo, thanks for the response.
I tried this and it worked for the first column but didn't for the other 4. I played around with indrect(address) myself and managed to get it working with:
It seems to be working right now. Sorry for all the fuss!=INDIRECT(ADDRESS(MATCH($BV7,$A$7:$A$1000,0)+6,MATCH(BW$5,$B$3:$BT$3,0)+1))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks