CSE formula help

[konew1]

I have a list of data that has names in column A, numbers in column B and other numbers in C:Z. I want to extract data from columns A & B from one row only.
I have the formula
{=OFFSET(A13,MATCH(C207,(J13:J204)*(K13:K204)-(O13:O204)-(P13:P204),0),0)} entered as array formula that correctly returns the name "Pacey"
Formula {=OFFSET(B13,MATCH(C207,(J13:J204)*(K13:K204)-(O13:O204)-(P13:P204),0),0)} returns "29".
If i create {=OFFSET(A13,MATCH(C207,(J13:J204)*(K13:K204)-(O13:O204)-(P13:P204),0),0)&OFFSET(A13,MATCH(C207,(J13:J204)*(K13:K204)-(O13:O204)-(P13:P204),0),0)} it gives "PaceyPacey". It is what I expect from the formula but not what I need.

If I create {=OFFSET(A13,MATCH(C207,(J13:J204)*(K13:K204)-(O13:O204)-(P13:P204),0),0)&OFFSET(B13,MATCH(C207,(J13:J204)*(K13:K204)-(O13:O204)-(P13:P204),0),0) } i get #Value!
Likewise =OFFSET(A13,MATCH(C207,(J13:J204)*(K13:K204)-(O13:O204)-(P13:P204),0),0)&OFFSET(A13,MATCH(C207,(J13:J204)*(K13:K204)-(O13:O204)-(P13:P204),0),1) gives #value. The expected result is "Pacey29"

What have I got wrong?

 

[fairwinds]

Hi,

Are you sure you remember to confirm the formula with Ctrl + Shift + Enter? If not you will get the #value! error.

If that is not the case, try to debug the formula by selecting parts of it and press F9. Thus you should see which part gives the error.

 

[konew1]

Thanks. Every part of the formula returned #value when tested with F9, but I have discovered the problem was the attempt to concatenate text to a number. That never works unless the number is converted. I was looking for a complex problem when it was simple.
=OFFSET(A13,MATCH(C207,(J13:J204)*(K13:K204)-(O13:O204)-(P13:P204),0),0)&TEXT(OFFSET(A13,MATCH(C207,(J13:J204)*(K13:K204)-(O13:O204)-(P13:P204),0),1),"0")