Hi, I have data listed in rows, with columns A:E making up the unique
identifiers. I want to match the 5 fields and return the data in the next
column. I could write a formula matching the 5 fields like this

=INDEX(F:F, MATCH(A2&B2&C2&D2&E2,A1:A500&B1:B500&C1:C500&D1:D500&E1:E500,
FALSE))

but it's kind of long.

Is there anyway to specify the range A:E, instead of explicitly writing
everything out?

Thanks