index match between 2 workbooks

[austenr]

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]

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]

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]

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))