Index/match between workbooks problem

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index Match error 1
Create if partial match then copy and paste data from one cell to another 1
Compare Two Columns 3
Macro to compare, find match and copy between workbooks 6
Match, Index and CSV 3
IF ISERROR with index match 3
using match function 1
Macro for index/match function 9

Top