looking equation in excel : table1 has these coloumns T1.start range, T1.End range, T1.avg value and table2 has these columns T2.range Value. i want to a column to table2 T2.avg value, condition replace T2.avg value with T1.avg value where T2.range value >= T1.start range and T2.value < T1.end range.
File attached with sample data
File attached with sample data
Attachments
Last edited: