VLOOKUP to Seperate Workbook and Input Dependant Sheets

[kdenhof]

Hello there,

This is my current VLOOKUP function, but it keeps returning the #VALUE Error:

=VLOOKUP(Job_1, INDIRECT(" ' "&INDEX(Manifold_Sheet_List,MATCH(1, - - (COUNTIF(INDIRECT(" ' "&Manifold_Sheet_List&" ' !$A$3:$V$102"),Job_1)>0),0))&" ' !$A$3:$V$102"),13)


I used two name conventions that cover tables of data:

Job_1 - Input Number List (e.g. 4456, 4522, 4633)
Manifold_Sheet_List - Sheet List (e.g. 4400's, 4500's, 4600's)

I used a VLOOKUP function previously on the Job_1 List.. so any input numbers are text, not numbers. I've ruled out the use of several options and it's come to posting a thread on here. Hopefully someone can give me some insight as to what I'm doing wrong.

[martindwilson]

indirect &countif do not work on closed workbooks is that your problem?

[kdenhof]

I opened both workbooks within the same window to figure it out. I also hit CTRL + SHIFT + ENTER for the VLOOKUP function. The result is now a #N/A Error. So I must be experiencing some small connection issue. I'm almost convinced it has something to do with my "..Sheet_List" connections. Would there be an appropriate way to input connections within these cells? (e.g. ='[file.xlsx]Sheet'!)

[kdenhof]

08-20-13 10-01-11 AM.jpg
This a general idea of what I'm trying to do

[martindwilson]

have you tried each part seperately