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
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
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.
choice wrote:
>
> 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
--
Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks