Lookup last non blank value – Excel Challenge - KING OF EXCEL

KING OF EXCEL

KINGEXCEL.INFO ( KING OF EXCEL ) Welcome KINGEXCEL.INFO - Nothing Is Unable ... About Excel Tricks, Learning VBA Programming, Dedicated Software, Accounting, Living Skills ...

Saturday, July 25, 2020

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.

Lookup last non blank value for a given account number

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

No comments:

Post a Comment