Thread: [Solved] merge 2q with 2q, then 2q with 2r, then merge 2s plus same text in each then same for rows 3,4,5,6,
View Single Post
 
Old 09-29-2016, 01:52 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,375
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Somehow, you've managed to make a mess of the formulae. For example, you now have:
=INDEX($C$1:$C$13,MATCH($V2,Q$1:Q$13,0))
in W2 instead of:
=INDEX($C$1:$C$13,MATCH($V2,R$1:R$13,0))
In order words, your formulae are referencing one column to the left of where they should be. Simply fix the referencing in W2, then copy the formula down & across to Y13.

You still have duplicates & missing entries in Column R & S...
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote