I have 2 lists in separate workbooks. The lists do not have the same number
of rows. I have been trying to create a formula to achieve a result, but have
been unsuccessful so I dont know if what I am trying to do is possible.
Below is what I want to accomplish.

On List1 I need a formula that will return a value from List2. I want to
enter the formula in List1_Column R.

If the value in List1ColumnQ = the value in List2ColumnN and the value in
List2ColumnF=€�y€�, return the value in List2ColumnO . Naturally, the List2
values columnN, columnF & colmunO must be same row.

Any help with this formula will be greatly appreciated. If I am unclear on
what I want to achieve, let me know so that I can hopefully clarify.

TIA
Jan