Google Sheets VLOOKUP MULTIPLE IF

is this possible to achieve in google sheets?

if A2=“Bangkok” (vlookup (products!B1:F100) OR else if A2=“New York”(vlookup (products!M1:S100)