Four-Column Index / Match w/ duplicates

[dohearn]

I have a spreadsheet with four columns

A B C D
Advertiser Industry / CreativeType / VideoType / Click Rate

I need a solution that will match a unique record for inputs A,B,&C and return the corresponding value in the final CTR column, D. I've tried an INDEX MATCH array combination, but the presence of duplicates is screwing things up (I think). For instance some sample lines:

Auto / Flash / Video
Auto / Rich Media / Non-Video
Auto / Rich Media / Video
Retail / Flash / Video
Retail / Flash / Video

I can't seem to find a way to make this work. Help is much appreciated, thanks.

[DonkeyOte]

You can use an Array - assume for sake of example that criteria A1:C1 on RESULT sheet and data stored on DATA sheet

Please Login or Register  to view this content.

If you want to handle Errors (no match) wrap the above in an outer IFERROR wrapper

I've tried an INDEX MATCH array combination, but the presence of duplicates is screwing things up

Assuming the CTR values are consistent for duplicates there should be no issue... if they are not you would need to determine which of the duplicates you would want to "match"

[dohearn]

whoa...thanks. that worked quite nicely.

- d