Index/match between workbooks problem
 

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/match between workbooks problem
 

Nevermind, I just figured it out...sorry!

"aileen" wrote:

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?