LinkBack URL
About LinkBacks
copy sheet a to sheet c
then use a vlookup in columns e ,f,g of sheet c
assuming row one is the headers id/name ect then in e2
=VLOOKUP($A2,'Sheet b'!$A:$D,COLUMN()-3,FALSE)
drag across to col g
then down to end of data
copy sheet a to sheet c
then use a vlookup in columns e ,f,g of sheet c
assuming row one is the headers id/name ect then in e2
=VLOOKUP($A2,'Sheet b'!$A:$D,COLUMN()-3,FALSE)
drag across to col g
then down to end of data
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks