How to get value, given "text" Column and Column

[aa_hei]

Your Task History ID

IjU3NjcwNTY1MDYzNjA0MzY1MjZkNTUzYzUxMzU1MTYxNTQzOCI_3D_pc

1. I've already gotten the telegram bot massage process to 2 texts to navigate the value
2. I'm stuck in google sheet part
my sample is like this

itemNo	US	MY	PH	SG	UK
73285195	62.97	54.55	57.89	54.05	60.74
72412180	59.72	51.29	54.64	50.79	57.48
74912195	62.97	54.55	57.89	54.05	60.74

for example， sent “73285195_US” telegram bot, then telegram bot reply me 62.97
1. telegram bot Webhook Done
2. Text split by separator Done
3. get "73285195"and "US",and match it in google sheet. However, I didn't find that function. Did I miss something?
I only find GoogleSheet--Lookup Spreadsheet row

 

[Pabblymember11]

Hey @aa_hei

We have made a workaround for your use case to find the country values from Google Sheets.

Though you only need to pass the column name in the Lookup Table action step which we have set up for you for all other countries.

So, please do the necessary changes once and try again.