Hello,

Can I use index / match for the following issue or should I be looking to use some other function? I've made a few attempts, but can't seem to get it to work.
Two Excel Files.

File 1- formula to be entered in this file. I need to match account number (column B of File1) with account number in File 2, plus if the value in File 2 (column Y>0) return the account number; otherwise return "No".

File 2 - account number column C, and value > 0 is in column Y.

Any help would be greatly appreciated.

TIA

Jan