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