Building a spreadsheet Therory

[itsrich]

I am building a spreadsheet with a column to look up a part number on another sheet.

=XLOOKUP(C2555,'S:\2024 Purchasing\[Columbus Export.csv]Columbus Export'!$D:$D,'S:\2024 Purchasing\[Columbus Export.csv]Columbus Export'!$E:$E,FALSE)

2500+ cells with the same formula.

Is it better to build with =XLOOKUP(C255,INDIRECT(reference to cell with path1)!$D:$D,INDIRECT(reference to cell with path2)!$E:$E,FALSE) (this formula is not correct, only for discussion)

How do I build the smallest, fastest-loading file using formulas such as the above?

Thank You In Advance!

 

[Fluff]

The 2nd formula will only work if the other workbook is open & will be a) slower & b) will calculate far more often than is needed.
If you are looking for efficiency, then you would be better off limiting your ranges, rather than using entire columns.

 

[itsrich]

TYVM Fluff! Change full column reference $A:$A to A1:A2500.

Fluff, since you did not suggest it, I take it XLOOKUP is The best option for my task. Repetition is the "bain" of Excel users?

 

[Fluff]

Not sure if there is a "best" way, but I would use xlookup.