•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
auto populate cells with values based on a known value that falls on or between data from 2 columns
i want to auto-populate 2 cells based on constraints related to a known value.
Using the below data:
I want to populate cells B22 and C22 with values from row 6, based on the value in cell B12.
For example, if B12 is 0.2, I would like to populate B22 with 5000 and C22 with 10000 as 0.2 falls somewhere between those 2 columns in my data set.
Using =forecast.linear, i've already got the calculation to determine the exact value between the 5000 and 10000, but i currently have to find which 2 columns my known value falls between and then manually enter the numbers into B22 and C22.
I was hoping there was a statement that would populate the cells for me.
Thanks
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#financial modeling with spreadsheets
#big data management in spreadsheets
#conversational data analysis
#cloud-based spreadsheet applications
#real-time data collaboration
#intelligent data visualization
#natural language processing for spreadsheets
#rows.com
#Excel compatibility
#row zero
#auto-populate
#B12
#known value
#B22
#C22
#cells
#forecast.linear
#data