=Index( Range, Row_num, [Column_num])

** INDEX** returns a cell value at a specific ** row** and ** column** .

A function such as ** MATCH** can be used to find the row or column number.

Range |
Range of cells in which the row number and column number can be found. |

Row_Num |
The row number is relative to the range .For example, if the range is B5:B10 then row_num 3 would be row 7 |

Column_Num |
If the Range is wider than a single column, the column number finds the correct column for the given row. |

In the above example, the first

It has a row number of

The fourth row in the range

The second

Since this range has

In this example the row is

Copyright © 2006-2016, LQSystems,Inc. All rights reserved.