Combine two iferror formula

[Learner1]

Hi

I am trying to combine two "iferror" formula. I do get the return value but for some reason the value appear on the left side of the cell. I tried to formatting the cell with options to General, Number, comma style etc but it didn't work.
this is the formula:
=IFERROR(LOOKUP(2,1/(Planning!A:A=O6)/(Planning!B:B=P6)/(Planning!C:C=Q6)/(Planning!D:D=R6),(Planning!E:E))," ")&IFERROR(LOOKUP(2,1/(Planning!A:A=O6)/(Planning!B:B=P6)/(Planning!C:C=$Q$4)/(Planning!D:D=R6),(Planning!E:E))," ")

or is there any alternate way.

Thanks

[AliGW]

Are ou still using Excel 2003? If not, please update your profile.

The formula as it stands will return concatenated values as text.

Try this:

=IFERROR(LOOKUP(2,1/(Planning!A:A=O6)/(Planning!B:B=P6)/(Planning!C:C=Q6)/(Planning!D:D=R6),(Planning!E:E)),"")&IFERROR(LOOKUP(2,1/(Planning!A:A=O6)/(Planning!B:B=P6)/(Planning!C:C=$Q$4)/(Planning!D:D=R6),(Planning!E:E)),"")

or this:

=--IFERROR(LOOKUP(2,1/(Planning!A:A=O6)/(Planning!B:B=P6)/(Planning!C:C=Q6)/(Planning!D:D=R6),(Planning!E:E)),"")&--IFERROR(LOOKUP(2,1/(Planning!A:A=O6)/(Planning!B:B=P6)/(Planning!C:C=$Q$4)/(Planning!D:D=R6),(Planning!E:E)),"")

or even this:

=--IFERROR(LOOKUP(2,1/(Planning!A:A=O6)/(Planning!B:B=P6)/(Planning!C:C=Q6)/(Planning!D:D=R6),(Planning!E:E)),"")+--IFERROR(LOOKUP(2,1/(Planning!A:A=O6)/(Planning!B:B=P6)/(Planning!C:C=$Q$4)/(Planning!D:D=R6),(Planning!E:E)),"")

Failing that, attach a sample workbook.

[Learner1]

Hi

I am trying to combine two "iferror" formula. I do get the return value but for some reason the value appear on the left side of the cell. I tried to formatting the cell with options to General, Number, comma style etc but it didn't work.
this is the formula:
=IFERROR(LOOKUP(2,1/(Planning!A:A=O6)/(Planning!B:B=P6)/(Planning!C:C=Q6)/(Planning!D:D=R6),(Planning!E:E))," ")&IFERROR(LOOKUP(2,1/(Planning!A:A=O6)/(Planning!B:B=P6)/(Planning!C:C=$Q$4)/(Planning!D:D=R6),(Planning!E:E))," ")

or is there any alternate way.

Thanks

I have uploaded the Workbook. Please refer cell "T2"

[Learner1]

I have uploaded the workbook

[HansDouwe]

Please try: =--(<your formula>)

[Learner1]

Hi

Thanks for your help. I am using the same formula where the return value is #VALUE!.
How could it be updated to have "0" if there #VALUE!, #N/A etc

[HansDouwe]

Please try:

=IFERROR(--(<your formula>),0)