Convert formula to use Indirect

[hollerg]

I would like to make it so the data on a separate sheet can be looked up,without having to manually outline the data each time. Normally the formula would look as follows, referring to tabulated data on sheet antistatic. Along the left is date&time values and across the top are unique labels

=INDEX(apestatic!$E$42:$L$2140,MATCH('Graphed data'!$E4,apestatic!$E$42:$E$2140,0),MATCH(H$3,apestatic!E42:L42,0))

on tab apestatic, I have formulas that determine the cell address of the corners of the tabulated data
top of left column $E$42
bottom of left column $E$2140
top of far right column $L$42
bottom of far right colum $L$2140
I was hoping to use indirect( ) and concantinate to create the ranges on the antistatic sheet, but I haven't figured out how creat the items in red. Suggestions?

 

[etaf]

what cells will these values actually be in
top of left column $E$42
bottom of left column $E$2140
top of far right column $L$42
bottom of far right colum $L$2140

 

[Aladin Akyurek]

Select apestatic!$E$42:$L$2140 and name the selection LTABLE via, e.g., the Name Box. Assuming that row 2 houses the headers, you can invoke anywhere or Graphed data...

=VLOOKUP($E4,LTABLE,MATCH(H$3,INDEX(LTABLE,1,0),0),0)

Is this set up something you can work with?