Refer to other cell with reference cell in Excel

For example, I maintain financial report for the year. To make it simple, I have set up a month selection field (cell F2), that would be used to show table data for that month only.

I have defined Monthend Date in a table. For the month selected, can I get Montheend Date without relying on VLOOKUP or Index / Match?

excel refer to other cell with reference cell

To do it in Excel, here is the answer:

a) Enter the formula =OFFSET(B2,F2,1) in cell F3 where Montheend Date for the Month selected is required.

The first argument "B2" is the reference cell in the Table (typically top left cell of the Table).

The second argument "F2" refers to the cell containing the row offset from reference cell. In this case, row offset is determined by user's choice of Month.

The 3rd argument "1' refers to the column offset from reference cell.

excel refer to other cell with reference cell

 

You can find similar Excel Questions and Answer hereunder

1) How do I enter a formula in a cell using VBA (using Absolute Reference)?

2) How can I identify the cells that influence a particular cell to help with debugging of my spreadSheet or understand a spreadSheet that I inherited?

3) How can I set the fill color, font color and set number format of cell to date?

4) How to find the column number from the cell address in VBA

5) How can I enter a cent symbol in a cell?

6) Remove the apostrophe cell text values in Excel

7) I want to add a trend indicator symbol next to my sales data - how can I do that?

8) How can I display fractions as it is in a cell (instead of displaying as a decimal)?

9) Can I add a small chart to Table data to make it visually appealing and easy to interpret?

10) How to see to which cells a cell is connected or used by. How to see the dependents of a cell

 

Here the previous and next chapter