Unsure why we are using cell A3 as a matching criteria. Cell A3 is just a column Header, but doesn't match same column header on the other sheet, unless you want me to name them the same?

Not sure what you mean by "rank N", on the 2nd parameter.
Please advise, thanks.