Menu

* *

This is very frequent situation when we need to find out the last cell in a row or column. We can get any value against the last cell. Let us find out the ways by which we can do this.

Usually , it is hard to run a check of different cells using the functions in Excel but even then we have a few which help in this regard. One of such function is LOOKUP. It runs from one end to other and looks up the value needed and return the value from the column which we have specified.

Suppose We have the following data in a row and we need to find the last filled value.

12 | 12 | 12 | 23 | 34 | 54 | 56 | 3445 |

As in the case of the row, sometimes we need to find out the value of the last filled cell in a column too. In this solution we’d find the way to find out the value of last filled cell in a column or any value corresponding to the last filled cell in a column.

Let us try to check the cells of a column and find out the last filled cell in a column. Usually this kind of task is easily done in VBA but we will still try in Excel. We’ll take help of LOOKUP function in this as this is a very basic function for looking up a value in a given table and it runs throughout the range.

Suppose We have the following data in a column.

RANGE |

1 |

3 |

23 |

4 |

54 |

5 |

6 |

Let us find out the last used row in a column i.e. the row which contains the last data in a row. We can take the leads from the above examples of finding the last used cell in a column.

Let us try to check the cells of a column and find out the last filled cell in a column. Usually this kind of task is easily done in VBA but we will still try in Excel. We’ll take help of LOOKUP function in this as this is a very basic function for looking up a value in a given table and it runs throughout the range.

Suppose We have the following data in a column.

RANGE |

1 |

3 |

23 |

4 |

54 |

5 |

6 |

OTHER WAYS TO REACH THIS ARTICLE

## WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

YOU MAY LIKE

- HOW TO TROUBLESHOOT A FORMULA IN EXCEL?
- USE OF FONTS, FONT SIZE, INDENTATION, TEXT TO THE RIGHT, TEXT TO THE LEFT, TEXT IN THE MIDDLE ETC.
- how to insert table in excel?
- FOR MORE ARTICLES, CLICK EXCEL OR TYPE IN SEARCH BELOW.