PDA

View Full Version : index match between 2 workbooks



austenr
08-31-2017, 05:40 PM
Havent posted in a few years. In the attached workbooks I would like to do an index match from workbook 2 to workbook 1 to return column 3. Have tried VLOOKUP without any success and dont really understand index and match that well. Any help and explanation appreciated in advance.

SamT
08-31-2017, 06:49 PM
if you want the Row number in Book2, column 3, that has the matching value in book 1? Just use MATCH where column "C" is the LookupArray

If you want the value in a different column of book2 in the same Row that MATCH returns, use INDEX+MATCH where MATCH is the Row reference for INDEX.

I think :)

austenr
08-31-2017, 07:19 PM
if you want the Row number in Book2, column 3, that has the matching value in book 1? Just use MATCH where column "C" is the LookupArray

If you want the value in a different column of book2 in the same Row that MATCH returns, use INDEX+MATCH where MATCH is the Row reference for INDEX.

I think :)
I think a sample would be most helpful and appreciated

austenr
09-01-2017, 06:25 AM
I tried this but I get a Value is not available error:


=INDEX('[Que 8-28.xlsx]Data sheet'!$B$8:B$35,MATCH(E240,'[Que 8-28.xlsx]Data sheet'!$D$8:D$35,0))