Combine two formulas

[PatrikIden]

Hello, i'm trying to combine two formulas: =OMFEL(Låda1!D:D;PASSA(A2;Låda1!A:A;0))+OMFEL(Låda2!D:D;PASSA(A2;Låda2!A:A;0)) but i gett an error (ValueError).
But if i Show calculation steps then the data/values i'm lookin for is there. But the point is that i only want one of theese values to show in the column. Any ideas?

Thank you.

[PatrikIden]

=OMFEL is =IFERROR by the way. And PASSA is MATCH

[shukla.ankur281190]

May be
=OMFEL(Låda1!D:D;PASSA(A2;Låda1!A:A;0)),Låda2!D:D;PASSA(A2;Låda2!A:A;0)))

Please Login or Register  to view this content.

[shukla.ankur281190]

May be
=OMFEL(Låda1!D:D;PASSA(A2;Låda1!A:A;0)),Låda2!D:D;PASSA(A2;Låda2!A:A;0)))

Please Login or Register  to view this content.

But Iferror value is also same? There is no sense between them.

[PatrikIden]

Thank's for your reply, but i get an error (Wrong formula)

[shukla.ankur281190]

Can you share your spreadsheet?

[PatrikIden]

Here you go: https://dl.dropboxusercontent.com/u/...ager_test.xlsx

[shukla.ankur281190]

USE =OMFEL(OMFEL(INDEX(Låda1!D:D;PASSA(A2;Låda1!A:A;0)),INDEX(Låda2!D:D;PASSA(A2;Låda2!A:A;0))),"")

Please Login or Register  to view this content.

[shukla.ankur281190]

Please check the attachment.

[PatrikIden]

I got this working now. Thank you.