| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index Match Problem | Excel Worksheet Functions | |||
| Index Match Problem | Excel Worksheet Functions | |||
| Possible index/match problem? | Excel Worksheet Functions | |||
| index & match with links for updating to other workbooks | Excel Worksheet Functions | |||
| dynamic, double vlookup, match, index, dget?? different workbooks | Excel Worksheet Functions | |||
Linear Mode
