claybwagner28
Board Regular
- Joined
- Sep 25, 2014
- Messages
- 67
- Office Version
- 365
- Platform
- Windows
Hello,
I have a running monthly total of sales. I type the value in Column L.
I have a formula which finds and returns the most recent entry. That formula is LOOKUP(2,1/(L2:L13<>””),L2:L13).
In column K is the corresponding month, Jan-Dec. What I would like is for excel to find the most recent month’s sales and return the value one cell to the left. So if I type in L4, I want it to return K3, which is the month in this case.
This seems easy, but I can’t seem to get it to work. I tried LOOKUP and INDEX and MATCH, but I can’t seem it get it right.
Any ideas?
Thanks in advance.
I have a running monthly total of sales. I type the value in Column L.
I have a formula which finds and returns the most recent entry. That formula is LOOKUP(2,1/(L2:L13<>””),L2:L13).
In column K is the corresponding month, Jan-Dec. What I would like is for excel to find the most recent month’s sales and return the value one cell to the left. So if I type in L4, I want it to return K3, which is the month in this case.
This seems easy, but I can’t seem to get it to work. I tried LOOKUP and INDEX and MATCH, but I can’t seem it get it right.
Any ideas?
Thanks in advance.
