Macro or Formula to compare multiple columns to other multiple column range

Hi,

I am working on a formula to compare two sets of columns and, if there is a match, to copy data from a specific cell. So far my formula looks like this:

=IFERROR(IF(INDEX($I$2:$I$5,MATCH(A2&B2&C2,$F$2:$F$5&$G$2:$G$5&$H$2:$H$5,0))="","",INDEX($I$2:$I$5,MATCH(A2&B2&C2,$F$2:$F$5&$G$2:$G$5&$H$2:$H$5,0))),"")

....I've attached an example sheet and what i'm after is that if there is a match between A/B/C column when compared to F/G/H columns then it returns the corresponding cell from column i into column D.

Using the formula above it is just returning an empty cell at present so any help would be appreciated!

AttachmentSize
Example.xlsx63.9 KB

RMartin

Try this "array formula" in cell D2

=IFERROR(INDEX(I:I,MATCH(A2&B2&C2,F:F&G:G&H:H,0),0),"")

Make sure to press Ctrl + Shift + Enter to confirm entry

Jon

This has worked a treat -

This has worked a treat - thanks Jon!