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!
Attachment | Size |
---|---|
Example.xlsx | 63.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!