Using cell values to build aurguments in lookup function

[Manual Labor]

I am trying to use the contents of cell B2 to build an argument for the
lookup function.

I keep getting a #value error.

=LOOKUP(A71,CONCATENATE(B71,"!A2:A282"),CONCATENATE(B71,"!E2:E282"))

A71 = date
B71= apple

so it should look like this (this works when i type it out)

=lookup (a71,apple!a2:a282,apple!e2:e282)

any ideas?

thanks for any help

 

[Aladin Akyurek]

=LOOKUP(A71,INDIRECT("'"&B71&"'!A2:A282"),INDIRECT("'"&B71&"'!E2:E282"))

 

[Manual Labor]

I really appreciate your help.

=LOOKUP(A71,INDIRECT("'"&B71&"'!A2:A282"),INDIRECT("'"&B71&"'!E2:E282"))