Hello all,

I'm currently setting up an invoicing spreadsheet, and have a formula which uses an INDIRECT and LOOKUP function to sum costs for the month selected by the user.

Is there a way to perform the following function
          A          B 
1         B          7
2         0         21
=indirect(A1&*row number*) - to return 7 when in row 1 and 21 when in row 2

Currently I'm having to use the following setup:

          A          B          C           D
1        B           7          1           =indirect(A1&C1) - returns 7
2        0           21         2           =indirect(A1&C2) - returns 21
This breaks somewhat when you have to insert a row and the numbering in columns C does not continue.

If anyone wishes to see an extract from my worksheet to see exactly what I'm using it for, please let me know.

Thanks,

Scriv