User Profile
benhollister
Copper Contributor
Joined Oct 30, 2022
User Widgets
Recent Discussions
Return value form list based on value of another cell
Hi Link to document: https://1drv.ms/x/s!AipojThikVxRgiRC0t__L2g9jnrH?e=6f584M I have a list of two columns (in sheet Award Data): Column 1 is Awards Column 2 is hours. Each award is given once a certain number of hours is reached. On worksheet "CUA Log" is a log of activities that results in a cell that contains total hours recorded (F4). I want cell I4 on CUA Log to indicate which award has currently been gained based on the total hours cell (F4). As more activities are added, the total hours increases and the cell indicating the current award gained should change when the appropriate number of hours has been reached. I currently use a nested If/Then statement but the lists are over 30 rows long and may change so I am interested if there is a neater dynamic approach. ThanksSolved1.3KViews0likes3Comments
Recent Blog Articles
No content to show