Lookup last non blank value – Excel Challenge

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

#evba #etipfree #eama #kingexcel

📤How to Download ebooks: https://www.evba.info/2020/02/instructions-for-downloading-documents.html?m=1