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