how to compare data in one formula

**legolas** · 05-12-2011, 04:15 AM

Dear all,

suddenly my formula i got earlier stopped working
as per attached i am trying to find similarites

if B2,C2 got any match along D and E as per yellow cells

then copy value from F into A (example as in A14)

i am using this formula
=IFERROR(INDEX(F$2:F$19,MATCH(B2&C2,D$2:D$19&E$2:E$19,0)),"")

but is not working,
please how to solve this

thank for usual help

**TMS** · 05-12-2011, 04:32 AM

It's an array formula. You need to enter it with Ctrl-Shift-Enter, not just Enter. You will see curly brackets ({})if you've done it correctly.

Regards

**zbor** · 05-12-2011, 04:34 AM

Or change it to:

=IFERROR(INDEX(F$2:F$19, MATCH(B2&C2, INDEX(D$2:D$19&E$2:E$19,,),0)),"")

and comfirm with normal enter

**legolas** · 05-12-2011, 05:02 AM

Originally Posted by TMShucks

It's an array formula. You need to enter it with Ctrl-Shift-Enter, not just Enter. You will see curly brackets ({})if you've done it correctly.

Regards

How did i miss that
yes it works, thanks a lot