User Profile
wrightjj
Copper Contributor
Joined Jun 18, 2023
User Widgets
Recent Discussions
range lookup
Am struggling with a range lookup. I have data being pasted from an online table coming in with cells going PNOV VALUES 0-100 30% 101-150 60% 151-200 90% etc. And am wanting to lookup data from one cell in my row if the label matches the table label and then pull data from a cell in that row if the data lies within the range of the table and if so take the value %number. E.g row to be pulled from with label being PNOV DPMO and cell I want to be referenced being 367: PNOV DPMO 167 then pulling it from the table with the label PNOV and then taking it from the cell 151-200, as 167 lies between these and then returning the value 90% Apologies if this isn't clear but thank you in advance for any help 🙂
