Lookup row and match against column

[hblbs]

Hi all, hope anyone can help.

In Sheet4 D2:AJ2, I have I have a list of values of which some are blank. In Sheet3 G2:G132 I have potentially one of the values in the array for Sheet4 D2:AJ2.

In AL2 I am trying to match the array in Sheet4 D2:AJ2 against the array in Sheet3 G2:G132 and give me the cell contents of that match in Sheet3.

In Sheet3 G2:G132 I know that only one of the cells will match one of the values Sheet4 D2:AJ2.

Thanks in advance. Please let me know if you need any further information.

 

[hblbs]

I am trying to use the formula below, but I would need P2 to be Sheet4 D2:AJ2. I am not sure how to make the work across two arrays.

=INDEX(Sheet3!G$2:G$132,MATCH(P2,Sheet3!G2:G132,1))