Indirect formula help needed.

[thilag]

Indirect formula help needed.

Hello friends

I want to plot the datas from Sheet 1 to Sheet 3 to Sheet `Datas' in light yellow cells.

Please find the attached MS Excel 2010 version file <Indirect formula help required.xlsx>.

thanks

thilag

[6StringJazzer]

First, why do you think that the solution requires INDIRECT? In the most trivial case you could just use direct links, if the layout of Sheet1-3 isn't going to change.

Second, this would be much easier if you did two things:

1. Design your data so that all the data for all the years is in one worksheet, instead of splitting it into three
2. Use column and row headers that match the column and row headers in the data source (for example, use "Current Ratio" as a header instead of "Current Ratio or Liqudity" [sic])

If you do those two things, then the solution is probably VLOOKUP (or INDEX/MATCH).

[thilag]

Instead INDIRECT we can use some other commands also if possible no problem. But i think if we use INDIRECT then even i make `N' number of sheets we don't have any problem to change the formulas, other wise we need to add the new sheet reference to the formulas once the new sheet sat Sheet4 is added.

For 2. It is ok to rename the datas i don't have any problem
For 1. i cannot do that, the reason is i am copying from net websites and pasting in excel and the format will allow me to paste the datas in new sheet every time instead already pasted.

thanks

thilag