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

Word macro that can call cells out of Excel for a find and replace 0
Create if partial match then copy and paste data from one cell to another 1
Transfer data between two tables 3
Index Match error 1
Return BLANK is cell value sought is blank 13
Index/match across multiple columns? 16
Index Match function for lookup HELP 5
Wysiwyg in Word 0

Top