Lookup the Last Value in a Column or Row in Excel | Get the Value in the Last Non-Empty Cell

In this video I demonstrate how to lookup the value in the last non-empty cell in a row or column in Excel. This can be achieved using the LOOKUP function.
------------------------

[jonr]

Searching for a solution, found this vid, watched the explanation, CLEVER!!

Thanks!

[martinduke]

As with others, I am glad I came across your explanation. Much appreciated.

[volkaman]

Thank you very much! I had a persistent problem in which my formulas were correct, but excel was not accepting them. It placed a red border around my cell. For anyone experiencing this, know that it has to do with your regional settings. All you have to do is change ", " to " ; " in your formula. Hope you won't have to look for hours like me :) Good Luck!

[DeepakGupta-ngni]

Scrolled through multiple results, finally stumbled upon your video, thanks a lot, this is the solution I was looking for (with blank cells)

[justindillon]

I just tried using this formula but it is returning the value in the top most cell, not the bottom. Any thoughts?

[thailandsnippets]

Thank you . I tried searching google for the answer to my problem and tried their suggestions but they didnt work. I looked at your video and my problem was solved instantly and very clearly.

[BrianPhillipsRC]

Thanks so much! This was killing me, but you saved the day!

[voiceofsoul]

Sir, I have a query i.e. i.e. in a row few cells have some value and few cells have zero value but if I use the formula shown in the video, the answer I am getting is zero as the last cell has the zero value. Kindly help me.

[princejoe]

good video, it gives me idea. But what I want to understand is how to get the last sale of the specific person. e.g. Bob.

[JITISH]

Thank you for this video, This formula works great, except for when there is an actual 0 in the data, then it takes 0 as the last value in the column instead of the last non-zero value before the zero. How can I account for this? And can this be changed to return the first non-zero value in a column? Thank you again, great video.

[dea.andrade]

This video was amazing. You are really good explaining! Thanks.

[CB-cytl]

I found this very useful! How can i amend the same formula to give the first value. not last ??

[bryan_kutal]

Invaluable formula! Thank you so much!

[narendrabishnoi]

Hey, your vedio is informative, just want to know how will it work with negative valves

[vanillavey]

instead of getting the last value, i keep getting the first value. please help

[sarkarji]

Thanks Sir searching many videos, but finally got it👍

[krushnakanth]

cam we use a lookup function in a non sequential cells
for example
find the last price of the product, when your data is in such a way that (quantity, price, value), (quantity, price, value), .... & these values are in a row

[willpatton]

Thank you. This is exactly what I needed explained because I was tired of reading unclear explanations and my self testing failing. This was clear and easy to follow. Well done! Thank you!

[mdca]

Thank you for a clear and concise explanation of the LOOKUP function and its use. It will be useful to have a video to show how you might LOOKUP the last value of a column/row from a different sheet within the same workbook (or even a different workbook). I needed this in my budget workbook so that I can start for example the month of February my February worksheet with the balance from the last entry in the January worksheet. =LOOKUP(2, 1/('Jan 22'!E3:'Jan 22'!E25<>""), 'Jan 22'!E25:'Jan 22'!E25). In position E3 in the February worksheet type this formula, and it will LOOKUP the last entry in worksheet Jan 22 in Column E from row 3 to 25. I only have 21 entries and allowed 4 more for later additions. Should you exceed 25 rows in your January worksheet, please remember to modify the number 25 in location E3 in the February worksheet to a number past your last row that includes your January balance. To use a location in a different workbook you will need to include the path to that workbook in the LOOKUP formula.

[DanielFlores-osfr]

Thanks for your video! by the way, how can I show the latest 5 records of a specific record or name in the list?