Matching 2 values to a table

[SHAYJOSH]

Hi,

I have a table of shifts (2 columns) In order to check that you work by the work rules.
for example: if you work saturday morning you cant work sunday afternoon.


list 01______________________ list 02
saturday morning____________ sunday afternoon
friday afternoon...____________ saturday evning....

(the list containig the wrong combinations)


I need to check IF cell A1 (shift) AND A2 (next day shift) = same combination(RAW) in the list = TRUE.

Tried usin IF with MATCH ( if raws numbers from the match equals each other then TRUE) but

the problem is some values (shift name) repetitive so no ggod :-(


HELP!!!

[JohnTopley]

Please post a file showing expected results.

[SHAYJOSH]

Added the file along with what i tried

TNX!!

shay.xlsx

[FDibbins]

Your formula is returning the correct answer...
=IF(MATCH(E8,J8:J16,0)=MATCH(E10,I8:I16,0),"X","V")
=MATCH(E8,J8:J16,0)=4
=MATCH(E10,I8:I16,0)=5
=IF(4=5,"X","V")

Maybe you meant...
=IF(MATCH(E8,J8:J16,0)<>MATCH(E10,I8:I16,0),"X","V")

[SHAYJOSH]

In the example file I Need it to show X becouse that shift is not allowd (in the file its showing the option i highlighted in blue)
If the combination is in the table show X as an indicator

[SHAYJOSH]

Bumping for some help...