How to find last non-blank value - Excel lookup challenge
Here is a tricky Excel lookup problem. You want to find the last non-blank value for a lookup value. Each value you want to lookup has multiple items in adjacent columns. You need to get the very last item as answer.
Watch the video to learn 3 possible solutions to this problem.
For more on this, visit https://chandoo.org/wp/lookup-last-no...
You can download sample workbook there.
#lookupLastNonBlankValue #vlookup #xlookup