extracting subarray from array - subarray to be used with index/match

Untitled.jpg

Hello guys would greatly appreciate your help. Image is attached.

I'm looking to return a part of an array depending on criteria. i.e. I want only the data from the NBG3 columns or NLCV columns which I will then do the common index/match to find a value within that part of an array.
Note: I am looking to do this with functions (without VBA) as i have no experience with vba..

Thanks guys, would appreciate a prompt response.

Regards,

Dbauddls90

not sure if image is attached properly.. sorry for the repost

heres the spreadsheet

For the information given, I created two named ranges:

_NGB3 = Sheet1!$C$3:$E$15 (cell P1 data validation dropdown)
NLCV = Sheet1!$F$3:$H$15 (cell Q1 data validation dropdown)

and a Formula:
=INDEX(INDIRECT($P$1),MATCH($Q$1,B3:B14,0),1) (cell R1)