Index match

Hello,

I am trying to use formula index match to match in a summary table. I want to add this formula in order to search in another spreadsheet for the value in cell GS 3.
When found, I want to retrieve the value of the cell next to the match.

In the first picture I have the spreadsheet with the summary.

In the second picture I have the spreadsheet where I am going to look for the value.

01.PNG

02.PNG

How can I do this correctly?

Thanks

NM

I forgot to explain that the different values I want to search are not all in the same column or row.
Do I have to do a dynamic search?
How do I perform this?

TY

Request to you kindly do provide Sample workbook with expected results.

I attached a sample workbook.

Hi nfmoreira,

Please find here attached sample workbook with Solution. Is exactly the same you are looking for. Please do let us know.

Please do mark thread as solved if the provided solution furnishes your requirement.

sample.xlsx

In this case it is correct. But the problem is that the value to match in sheet 2 is not always in same column, it varies.
In case of 100 entries of data, the formula you provided would not work because I would have to alter the formula for each entry.

Thanks for your help Neilesh

Glad to help. Please mark thread as solved if the provided solution furnished your requirement.

Hi nfmoreira, Since you have asked for the single match so accordingly i provided. Please find here below the solution based upon the column Headers.

=INDEX(Sheet2!A:FO,MATCH(Sheet1!S3,Sheet2!CI:CI,0),MATCH(U2,Sheet2!A1:FO1,0))

Hi!
I forgot about the column headers. That's great.
Regarding the first match MATCH(Sheet1!S3,Sheet2!CI:CI,0), that only works if the value I am searching is in that column. How can I make fail safe and make it so that this match searches for the value in all columns?
I tried replacing that part for MATCH(Sheet1!S3;Sheet2!A:FO;0) but it does not work.

Thank you FDibbins.
I will take into acount what you said and be more explicit next time

Try this nfmoreira,

=INDEX(Sheet2!$A:$FO,MATCH(Sheet1!$S$3,Sheet2!$CI:$CI,0),MATCH(AC2,Sheet2!$A$1:$FO$1,0))

Thanks for helping me in this issue.
I attached an example workbook with one more row of results.
In this case, that formula only works for the first row. The value in the second row of results of sheet 2, is in a different position and with a different header.
How can I make it so that, no matter where the value is, I can find it and retrieve the value of the cell to its right?