ExcelBanter - Ref from table to cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Ref from table to cell (https://www.excelbanter.com/excel-worksheet-functions/32043-ref-table-cell.html)

Steve

Ref from table to cell

I have a table, such as:
Sheet 3
a b
1 125 1
168 2
259 3
345 4

All times are GMT +1. The time now is 01:14 PM.