Using cell values to build aurguments in lookup function

M

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
 
A

Aladin Akyurek

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup against concatenated source value 4
concatenate if 2
VLOOKUP source values are a formula result. Getting #N/A 7
SUMIF & INDIRECT problems 8
use cell text in lookup function 3
Adding cells until they are greater than a lookup cell and returning a value 1
Hlookup 0
Lookup / Summary Table 0

Top