Performance issue

[kweaver]

I have a sheet that concatenates text with the result of a formula...and this process happens several times within a given cell.
For example, I have to find a person's ID in a column and then extract an assortment of data from other cells accordingly.

Two choices work: (1) using XLOOKUP repeatedly such as
="blah blah blah" & XLOOKUP(B1,People!B3:B5000,People!C3:C5000) & "more blah, blah" & XLOOKUP(B1,People!B3:B5000,People!H3:H5000) & "more blah blah"

or (2) using XLOOKUP once, place the result in a cell and then use INDEX repeatedly such as: =INDEX(People!C3,C5000,A1)
Where A1 contains the row from ONE XLOOKUP.

Is there any performance issue that would favor one approach over another?

 

[Alex Blakenburg]

I don't have any reason to believe that there is a significant performance difference between XLookup and Index.
Since XLookup is an option for you, you most likely can use the LET command. This can reduce the need to do repeated whole of range Lookups so you only need to lookup each row once.

Book1
	A	B	C	D	E	F	G
1	Data
2
3	Fruit	Colour	Status	State		Input	Return Value
4	PEAR	GREEN	SOFT	NSW		Pear	PEAR more text SOFT Even more text GREEN
5	APPLE	READ	SOFT	VIC
Sheet1

Cell Formulas
Range	Formula
G4	G4	=LET(iRow, XLOOKUP(F4,$A$4:$A$5,$A$4:$D$5),INDEX(iRow,0,1) & " more text " & INDEX(iRow,0,3) & " Even more text " & INDEX(iRow,0,2))