Find last X values from column J excluding blanks, return value from column A

I have a worksheet that has about 30 rows and 11 columns of data that pulls from another workbook - it's a dynamic list that may have 3 rows of data or 20 rows of data. I am trying to figure out how to pull the last 8 values (excluding blanks) from column J, and return the corresponding value from column A.

I would need to do this possibly for all the columns at some point, but that's one the one I'm starting with. Attached is a sample file of what I'm trying to do. I want a formula that pulls the list (I put it over to the right for example).

Note: this file doesn't have formulas, but there are IndexMatch formulas in Columns B-J.

Thank you for your help.

array

Formula:

Please Login or Register  to view this content.

non array

Formula:

Please Login or Register  to view this content.

Cell O7 formula

Formula:

Please Login or Register  to view this content.

Another option in-case you may not have 8 rows of data

Formula:

Please Login or Register  to view this content.

@wk9128 with your formula try putting a value in J2 or J3

Thank you everyone - I think the formula Fluff13 provided will work the best. I tried implementing the others and got errors, most likely from the fact that I don't always have 8 or more rows of values. It's a changing list that may be as few as one or two lines.

Glad to help & thanks for the feedback.