Hello All,
I'm trying to use INDEX/MATCH to pull data from one workbook, managed by a seperate department, to a workbook my department uses to track progress during different product launch phases. I thought about using VLOOKUP but I can't garuantee that the other departments workbooks will be in sequential order. The formula I currently have is as follows
=INDEX('K:\PC\PC-Logistics\RECEIVING\[Parts Location MASTER COPY1 GREGS 2.xls]Sheet1'!$E$2:$E$1100,MATCH(C5,'K:\PC\PC-Logistics\RECEIVING\[Parts Location MASTER COPY1 GREGS 2.xls]Sheet1'!$A$2:$A$1100,0))
In this I am looking for a part number located in cell "C5" using match in the range A2:A1100
I am then pulling the part location from range E2:E1100
After I enter the formlyat I get #N/A in the cell. It gives me a "Value Not Available" error. Then when I step through the evaluation it tells me, concerning the contents of C5, "The cell currently being evaluated contains a constant."
In this instance the contents of C5 are "427195-10210". The cell is formated as general as is the cell I am pulling from. I appreciate any help that can be given.
Thank you,
Allen
I'm trying to use INDEX/MATCH to pull data from one workbook, managed by a seperate department, to a workbook my department uses to track progress during different product launch phases. I thought about using VLOOKUP but I can't garuantee that the other departments workbooks will be in sequential order. The formula I currently have is as follows
=INDEX('K:\PC\PC-Logistics\RECEIVING\[Parts Location MASTER COPY1 GREGS 2.xls]Sheet1'!$E$2:$E$1100,MATCH(C5,'K:\PC\PC-Logistics\RECEIVING\[Parts Location MASTER COPY1 GREGS 2.xls]Sheet1'!$A$2:$A$1100,0))
In this I am looking for a part number located in cell "C5" using match in the range A2:A1100
I am then pulling the part location from range E2:E1100
After I enter the formlyat I get #N/A in the cell. It gives me a "Value Not Available" error. Then when I step through the evaluation it tells me, concerning the contents of C5, "The cell currently being evaluated contains a constant."
In this instance the contents of C5 are "427195-10210". The cell is formated as general as is the cell I am pulling from. I appreciate any help that can be given.
Thank you,
Allen
