Lookup last non blank value – Excel Challenge
I have a fun Excel lookup challenge for you. You have data as shown below and want to find the last non blank value for a given account number. For example, for acct number 2015, the answer would be Freedom.
How would you solve this?
Refer to this workbook for 3 possible answers. Just move the white box away to see the formulas.
If you have a different solution, post it in the comments section.
Fine print
- Assume your data is in range A4:G13 with A4:A13 having the Account number and other columns containing some details.
- The lookup value can be hardcoded or assumed be to in cell K3.
- Click here for sample data file. This file also has some hints and 3 possible solutions.
- You can use any Excel formula or Power Query or VBA based solution.
- Post your answers in comments.
Happy solving.
Solution Video
📤How to Download ebooks: https://www.evba.info/2020/02/instructions-for-downloading-documents.html?m=1
Hi, I'm Mr KING Admin of KINGEXCEL.INFO .Thank you so much and I hope you will have an interesting time with KINGEXCEL.INFO. Mail: quantriexcel@gmail.com - PHONE : +84779313987.