LOOKUP

  • Thread starter Thread starter StuartCarnachan
  • Start date Start date
S

StuartCarnachan

Hi there

I have seen this done but cannot remember the formula

I have a data master sheet in which various monthly data is enterered month by
month.
I then have various monthly worksheets behind the data master.
I wish to access the data master sheet month by month.In the data master sheet
in A1 is the column ref say G.In say G 20 I have the fiq 9
In the monthly works sheets is a formula that refers to A1 in the data master
sheet and then looks up column G and position 20 to return 9.
The ref in A1 can be chaged month by month thus the data will change
accordingly.
Can any one help
e-mail (e-mail address removed)
 
Hi
not sure how you evaluate the row number 20 but maybe the following is
what you want:
=INDIRECT("'master_sheet'!" & 'master_sheet'!A1 & "20")
 
Back
Top