Forum Discussion
Solved
Value Error
Dear Experts, I have few questions on my calculation below:- Q1) In "C2", I need to populate the value from Column "Z", corresponding to the value set in N5, So, if I set N5 = t...
You say it is "breaking this" but don't say how. This should work, maybe try again?
=WRAPROWS( SEQUENCE( ,C3,0),C2, "x")
alternatively you can do a replacement using IF:
=LET( orig, SEQUENCE( ROUNDUP( C3/C2,0), C2, 0, 1), IF( orig<=C3, orig, "x")
The problem is how you are using that control. That control will place the INDEX number into that cell from the list so select "two" inserts the number 5 into the cell because that is the 5th in the list and the item "8" is actually the 7th in the list.
So either add INDEX() to your formula or just use Data Validation instead (I added that option to the sheet for you to see)
edit: i will try attaching again. the orig file was .xlsm which this server doesn't like so the attached is an .xlsx