indirect lookup

C

choice

i have vlookup(a1,indirect(b1),2,0
the value in b1 however is a range in another open workbook
[data.xls]setup!a1:b1000

i cant seem to get it to work, any ideas?

thanks in advance
 
D

Dave Peterson

Your formula worked ok for me.

I suspect a typo error or maybe you're getting an #n/a because there is no
match.

You may want to provide more details.
i have vlookup(a1,indirect(b1),2,0
the value in b1 however is a range in another open workbook
[data.xls]setup!a1:b1000

i cant seem to get it to work, any ideas?

thanks in advance
Click to expand...
 

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

Indirect formula errors if file is closed 0
Vlookup and return sheet name also 2
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
How to get a blank cell instead of a "0" 2
indirect formula syntax 2
Help with Address(), Indirect(), Offset 2
Using SUM(INDIRECT()) 2
trouble with (complicated) vlookup searching another workbook 2

Top