Return multiple values from all columns which meet...

[sudomtha]

Hello,

Is it possible to perform a lookup with multiple criteria on Airtable?

Similar to this:

Sheetaki – 24 Apr 21

How to Use INDEX and MATCH Function with Multiple Criteria in Google Sheets:...

The ultimate guide in understanding and using the INDEX and MATCH function with Multiple Criteria in Google Sheets. Learn exactly how to use the INDEX and MATCH function with Multiple Criteria in Google Sheet.

Est. reading time: 12 minutes

Example data table:

Item / Size / Color / Availability / Price
Shirt / L / Red / Yes / 3.00
Shirt / M / Blue / Yes 5.00
Jeans / S / Black / No / 10.00

Lookup Columns:
Item / Size / Color

Return:
Availability / Price