help me for vlookup by conditon.

[fairyme]

Hello,

I have 2 file excel (file input and master) as attached.
I want write formula in AH-AJ as detail below.


chk1
-chk column c in file input match with column C file master
-chk all column W file master that have value (not null or Chk) --> last row that match
-if found write Y , not found write N or not found value column C in file master write A in column AH file input

chk2
-chk column C and column P in file input match with column C and column R in file master
-chk all column W file master that have value (null or Chk) --> last row that match
-if found write Y , not found write N or not found value column C in file master write A in column AI file input

chk3
-chk column c in file input match with column C file master
-chk all column W file master that have value (null or Chk) --> last row that match
-if found write Y , not found write N or not found value column C in file master write A in column AJ file input

I want to solution by VBA or formula.


Thank you for advance.