A
aileen
I am using the following statement to match two cells between workbooks:
=INDEX(pgv!$X:$X,MATCH(X1,spxsymbols.xlsm!$G:$G,0))
My problem is that I want the value from cell H in the spxsymbols.xlsm to
appear in the cell Y from pgv.xlsm once a match is found for the X cell in
pgv.xlsm. I am using this statement in the Y column of the pgv workbook and
it is returning a 0 when it finds a match. Is it possible to return a value
that is not within the range I am matching?
=INDEX(pgv!$X:$X,MATCH(X1,spxsymbols.xlsm!$G:$G,0))
My problem is that I want the value from cell H in the spxsymbols.xlsm to
appear in the cell Y from pgv.xlsm once a match is found for the X cell in
pgv.xlsm. I am using this statement in the Y column of the pgv workbook and
it is returning a 0 when it finds a match. Is it possible to return a value
that is not within the range I am matching?