Hello guys,
I need help in a (for me) complicated problem.
I have 2 tables (see attachment).
If the cell I5 ist identical to one cell in the cells B5:B37 AND at the same time cell J5 is identical to one cell in the cells C5:C37 AND the cell in the column F, which is in the same row as the identical cells, then I need a comment (for example X) in cell M5.
For Example in the attached screenshot I need a X in Cell M15, because the first two cells in table 1 in row 8 are identical to the first 2 cells in table 2 in row 12 AND in cell F8 is a number instead of nothing.
I would appreciate any help you can give me.
Yours, Secundus
Bookmarks