Function Problems

Run an Excel LET Calculation for Each Range Value Without LAMBDA

Jason MillerJason Miller Nov 18, 2026 868 views

Question details

Run a complete LET calculation independently for each value in a range without LAMBDA, SCAN, or similar iteration functions.

Run an Excel LET Calculation for Each Range Value Without LAMBDA
Product
Microsoft Excel
Device & OS
not provided
Scenario
A working LET formula needs to process each value in the named range peaks_position.
Observed behavior
The formula works for one value but does not repeat the complete calculation independently for every value in the range.
Before you start

Identify which reference in the working formula represents the current input value and which ranges must remain fixed. Check that LET is available in your Excel version and that you have empty cells beside the input range for results or helper calculations.

Solution 1Recommended

Fill the LET Formula Down for Each Input Value

Use a separate copy of the working calculation for each input when it returns one result per value.

1
Locate the first input

Find the first cell in the peaks_position range, such as A2, and select an empty cell on the same row for the result.

2
Adapt the formula

Enter the working LET formula in the result cell. Replace the reference used as the current input with the first input cell, such as A2; keep any references that must still use the full range.

3
Fix shared references

In the formula bar, use absolute references such as $D$2:$D$100 for shared ranges that must not move when the formula is copied.

4
Copy the formula down

Select the result cell and drag its fill handle down alongside all values in peaks_position. Check that each copied formula refers to the input on its own row.

Fill the LET Formula Down for Each Input Value
Multiple-cell results: If each calculation returns multiple cells, give each input a separate output block with enough empty space rather than filling formulas into overlapping spill ranges.
Free Microsoft Office alternative

Work With Per-Row Calculations in WPS Spreadsheets

WPS Office is a free, lightweight Office alternative with a familiar spreadsheet interface. Open compatible Excel files and use filled-down formulas or helper columns for per-row calculations; check formula compatibility when moving a workbook between applications.

Build per-row calculations with formulas and helper columnsOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interface for an easier transitionWork with a free, lightweight Office suite
microsoft office alternative - wps office

Frequently Asked Questions

Can LET run the whole calculation separately for every item in a range?

LET names intermediate expressions but does not itself provide a per-item iteration mechanism. Some expressions work on arrays directly, but a calculation that requires independent execution may need separate formulas or helper ranges.

How do I keep a lookup range from changing when I fill the formula down?

Edit the reference in the formula bar to use absolute references, such as $D$2:$D$100, before dragging the fill handle down.

What if LET is not available in my Excel version?

Move the intermediate expressions into helper columns, then enter a final formula that refers to those cells. Fill the formulas down for each input value.

Can I automate the repeated calculation without LAMBDA or SCAN?

VBA or a worksheet event may be appropriate if the workbook supports macros and the process must run automatically. Otherwise, filled-down formulas or helper columns avoid requiring macro code.