Hi all,
I need a formula that looks at a section id say UW2022 in one field and a number which represents that say in another field next to it 300. Then i want it to look at another table lookup which says UW2022 in one field and next fields on that line the values between that section id say field 1 100 and field 2 400. So it would then return it as a true statement that 300 was between that range for UW2022 100-400
Bookmarks