• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

looking equation to get relevant value of table 2 based table 1

SaleemPP

New Member
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
 

Attachments

  • SaleemPP-1.xlsx
    12.6 KB · Views: 4
Last edited:
Many thanks for it. You've provided a really clear and concise solution.

I could obtain something else (more difficult).
=IFERROR(INDEX($C$2:$C$61,MATCH(1,($A$2:$A$161<F2)*($B$2:$B$161>=F2),0)),"")
 
Back
Top