2 Column Search Options then Show Results (Google Sheets)

Please try at A6

=INDEX((G$20:G$23,G$27:G$30),MATCH(INDEX($A$1:$B$1,CELL("col")),INDEX(($G$20:$G$23,$G$27:$G$30),,,CELL("col")),),,CELL("col"))

trying to delete this reply

Hi Bo_Ry,

I tried it in Google Sheets but it didn't work, I've been trying to solve it but could not. Why would it give me an "ERROR Formula Parse Error" in Google Sheets but not in Excel. hope you could help. here is the link https://docs.google.com/spreadsheets...it?usp=sharing

Please Login or Register  to view this content.

Or just this one?

Why dou you want 2 lookup cells instead of 1?

In this case, A1 cell should look only in Team A data while if User needs to look at Team B data, then User should type in B1 cell. In Excel, the formula shared by Bo_Ry works but it doesn't work in Google Sheet which I need to use it there too. In Google Sheet, it gives me "ERROR Formula Parse Error". You can check it here, https://docs.google.com/spreadsheets...it?usp=sharing

Sorry for the interjection, but how has this evolved into a Google Sheets issue?

You said this:

Need your expert advise on how to do this in EXCEL version 2019

What am I missing?

OK - as this is now more about Google Sheets, I'm moving it to the appropriate section.