Airtable doesn't natively support VLOOKUP functionality, but the answer is pretty easy: In Table 1, just convert your 49 answer fields into linked record fields. Then convert your 49 response fields into lookup fields… each one would be based on its associated answer field.