Look up / Pull Value even if multiple iterations

[Amanda88R]

I am currently using INDEX MATCH to look up values across multiple sheets. However in the data it needs to compare there can be multiple iterations of the look up value. This is currently causing me issues.

To explain - we are tracking whether post numbers match the VERIFIED posts on the Prevalidated Rotation Tab (this is all dummy data) There can be multiple instances of this post BUT the Post number and the Site and Sequence Number have to MATCH. Currently using the formulas below as soon as the ones in yellow are added most of my posts dont match even though they are all on the prevalidated tab
So I think I need it to just look up IF a post exists in the data not WHERE

Prevalidated rotation formulas
concat 2 = =CONCAT([@[Seq No.]],[@Site],[@[National Post Number]])

Rotation 1 formulas

concat 2	concat	found on prevalidated grid
=PVR[@[concat 2]]	=CONCAT([@[Seq No.]],[@Site],[@[National Post Number]])	=IF([@[concat 2]]=[@concat],"post match","posts don’t match")

Rotation 1 sheet

Prevalidated Rotation Sheet

 

[sijpie]

Can you not use a simple MATCH in column C?
IF(MATCH(Bx,'Prevalidated Rotation Sheet'!A:A, 0), "post match","posts don’t match")