Lookup based on two fields?

[Ann_Yeom]

Hi is it possible to tell airtable to look at two fields and look it up/match the fields on a different table and return the corresponding value?

For example:
Looking at the first image, L5 field (Media Engineering) and the size field (s) lookup the value for “s” in another table, second image, AND for Media Engineering and return the corresponding value? In this case it should return 20%.

Any suggestions welcome! Thank you!

[Ann_Yeom]

Nathaniel_Granor:

SWITCH({11/22 Size},
  "XS",{XS (from L5)},
  "S",{S (from L5)},
  "M",{M (from L5)},
  "L",{L (from L5)},
  "XL",{XL (from L5)},
  ""

Oh my goodness! I should have known that, :grinning_face_with_sweat: lol. Thank you! Thank you!

This works great! Thanks so much!!