matching multiples fields in 1 row

H

Hobochunk

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need a proper guru! My head hurts ;( 1
Excluding Repeating Numbers Help!1 5
Turning rows of equal number of columns into 1 continuous row 1
Need Formulas for counting multiple conditions 4
column to row draging 1
Over time? 4
COUNTIF with multiple criteria doesn't work 5
Calculate from another sheet - special 2

Top