Locate the position of a lookup value

For finding the positions of values within a column followed by the corresponding value from next column in EXCEL there is a function VLOOKUP(), but its solution can also be used for other functions.

to search For values in the intersection of the row and column you want the table of a special type: in the header row and the leftmost column should be non-repeating values.

Find the line number of the last filled cell in column a and the list. The row number of the find the value.

Select the range that contains 5 of the last filled cell in the list. If the column values are constantly filled, this task is no longer trivial.

Find a formula which returns a reference to the range containing the last 5 values. If the column values are constantly filled, this task is no longer trivial.

Finding maximum/ minimum values - a simple task, but it is slightly more complicated if the M

For finding the positions of values within a column followed by the corresponding value from next column in EXCEL there is a function VLOOKUP(), but its solution can also be used for other functions. Consider the problem in the case of text values.

there is developing article ideas Search position in the Text value and displays a corresponding value from next column. For finding the positions of values is case-sensitive, followed by the corresponding value from next column VLOOKUP() cannot be invoked, because it is not case sensitive. The problem can be solved with the aid of the functions DGET(), FINA() or EXACT().

here are the search numbers in the list with repetitions. Setting as a criterion to search for the desired value and number of repeat in the list, find the row number containing this repeat, and select it and other repetitions of this numbers using Conditional formatting.

Consider the search text values in the list with repetitions. By setting the criterion to locate the text value and number of repeat in the list, find the row number containing this repeat, and scroll to it, and other duplicates by using Conditional formatting.

this article attempts a classification of problems to find the values in MS EXCEL. The article may be interesting for advanced users of EXCEL. 

Find the average of the last 5 last values in the list. If the column values are constantly filled, this task is no longer trivial.

Find address of cell containing maximum value in the list.

Derive value from the last filled cell in the list. The list should not contain gaps (blank lines). The solution will work for both numeric and text lists.