Need help on excel formula

[redclay]

Hi, thank you in advance for your help on this.

Need help on the attached formula along an array of numbers that matches an above number.

Very grateful to have a platform to help with my excel shortcomings.

 

[ETAF]

=IFERROR(HLOOKUP(B6,$B$2:$F$3,2,FALSE),"")

 

[redclay]

=IFERROR(HLOOKUP(B6,$B$2:$F$3,2,FALSE),"")

This works great, thank you!

 

[ETAF]

you are welcome

 

[Peter Bartholomew]

There are alternatives. Firstly a word of warning. I program specifically for 365; I only work with defined names, never direct cell references; I only work with array formulas, never scalars. That makes my formulas look pretty unfamiliar to most!

= XLOOKUP(counter, period, amount,"")

= TOROW(EXPAND(amount, 5, , ""),,  TRUE)

The first uses XLOOKUP which has the 'not found' condition built in. The second does not perform lookups at all but, instead, relies upon the pattern of requiring values to be distributed to every 5th cell.