Hi there! I've been struggling with this formula for a couple of days now and I keep deleting it and starting over.
This is the chart on a separate tab named "Notice Weeks" that I need to lookup. I highlighted all the information and named it severance5
This is my first tab (CA Tracker) where I will be filling column CO with the formula, I have the same entity column, and work state column as in the 2nd tab with the chart (Notice Weeks).
I'm dealing with looking up information in a chart on another tab and having that input into the first tab.
example of 1 scenario:
I basically need to say if entity is (column A), and work state is (column AN) and the years of service (column CH) is greater than (column D in "Notice Weeks") and less than (Column E in "Notice Weeks"), the notice period will be (Column C in "Notice Weeks"). That will be filed into column CO.
Would someone be able to assist me with this? Tried googling/youtubing but it's been a fail.
This is the chart on a separate tab named "Notice Weeks" that I need to lookup. I highlighted all the information and named it severance5
This is my first tab (CA Tracker) where I will be filling column CO with the formula, I have the same entity column, and work state column as in the 2nd tab with the chart (Notice Weeks).
I'm dealing with looking up information in a chart on another tab and having that input into the first tab.
example of 1 scenario:
I basically need to say if entity is (column A), and work state is (column AN) and the years of service (column CH) is greater than (column D in "Notice Weeks") and less than (Column E in "Notice Weeks"), the notice period will be (Column C in "Notice Weeks"). That will be filed into column CO.
Would someone be able to assist me with this? Tried googling/youtubing but it's been a fail.