Is it possible to lookup each value in an array?

[excelos]

Hello

I have an array that returns {A,B}

I want to replace A and B by XLOOKUP(A,A:A,B:B)&" "&A and XLOOKUP(B,A:A,B:B)&" "&B

I am struggling because it seems I need some kind of loop to do that as the array can contain any number of values.

Any idea?

Thanks!

 

[StephenCrump]

Just a guess, because I'm not clear what you mean by an array that returns {A, B}?

Are you looking for something like this?

Book3
	A	B	C	D	E	F	G	H	I
1
2				MyArray1			Result1
3				13	7	5	E 13	C 7	B 5
4	3	A
5				MyArray2			Result2
6				3	13		A 3	E 13
7	5	B		5	3		B 5	A 3
8				7	7		C 7	C 7
9	7	C		11	5		D 11	B 5
10
11	11	D
12
13
14
15	13	E
Sheet1

Cell Formulas
Range	Formula
G3:I3	G3	=XLOOKUP(MyArray1,A:A,B:B)&" "&MyArray1
G6:H9	G6	=XLOOKUP(MyArray2,A:A,B:B)&" "&MyArray2
Dynamic array formulas.

Named Ranges
Name	Refers To	Cells
MyArray1	=Sheet1!$D$3:$F$3	G3
MyArray2	=Sheet1!$D$6:$E$9	G6