Excel Forums Screenshot.PNG
Hi
I'm trying to organize some data into separate setpoints. So on the right I have 2 columns of data D_AVG_N and D_AVG_TQ in columns I and J respectively. In column K want to assign each row a setpoint in accordance with the table on the left. For example row 13 has a D_AVG_N of 1500 and a D_AVG_TQ of 80 so is at setpoint 5. I was trying to make an array formula with the index function but I cant seem to get it to work.
Thanks in advance.
Bookmarks