How can I use index match if it wasn't in one column?

Copper Contributor

Good day! As stated above can someone help me. I am using index match but I find it hard because it wasn't in a same column.I want to get the specific data for example I select 1 or any number. Please take a look at this. https://www.dropbox.com/s/aheew349r8x4rvv/Error.xlsx?dl=0

4 Replies
Your sheet is protected, besides your requirement is not clarified.

you want to return in the printing sheet multiple values right?

My bad. Yes!  I want to create another sheet which display the PRN, NAME, POSTN and the specific cell value whenever I choose any number from F11:AJ31). 

Like this one: https://imgur.com/a/SBbAt47. Thanks

I am still confused with this, you do not have data up to AJ31 did you mean AJ11.
I just didn't fill it up. All I want is to make a cell that will display like what in the second picture.