Indexing Horizontally

[krazyness]

Good Evening,

I've been spending hours trying to achieve this and I believe I'm close but about to give up. Below is my data.

1

3810​

V3

1/12/2016​

21.4​

0​

0​

137.8​

137.8​

PIF

BJ M

AH

3/1/2019​

2801​

3810​

3810​

2801​

2

3811​

V39

1/12/2016​

117.56​

0​

0​

0​

0​

LGL

BJ M

AH

3/1/2019​

2801​

3811​

3

3812​

V30

1/12/2016​

155.31​

0​

0​

0​

0​

LGL

BJ M

AH

3/1/2019​

2801​

3812​

4

3813​

V301

1/12/2016​

217.27​

217.27​

0​

0​

0​

XRC

BL J

AH

3869​

3813​

3813​

3869​

P is a Vlookup from an entirely different workbook. It finds:

=IFERROR(VLOOKUP(B62,[300codes.xlsx]alrtj941!$C:$D,1,FALSE),"")

Q is

=IF(P62="", "", (VLOOKUP(P62,B:N,13,FALSE)))

What I now need is to count the times that row Q exists in row N when P and Q are going to be blank because they didn't meet the Vlookup criteria.

I googled and found:

=INDEX($B$2:$B$6, SMALL(IF(A$2:$A$9="excel", ROW($A$2:$A$6)-ROW($A$2)+1), COLUMN(A1)))

I Converted it to:

=INDEX(O:O, SMALL(IF(N:N=Q62,ROW(N:N)-ROW(N:N)+1), COLUMN(N62)))

and fail.

Any Help would be much appreciated.

Thanks!