Using Vlookup or Index/Match across 2 workbooks

[DataKnight]

Hello
Struggling to get a Vlookup or an Index with Match to lookup a table of data in one workbook and get any corrresponding data from the other.

I have a list of products in my first workbook which has monthly units sold in it. The second workbook has a manually copied Pivot Table of summarised BOM movements for products ie pasted as values. This 'table' only has a few products in it.

Both workbooks have data extracted via ODBC from our accounting software.

I need to search for products that match in both tables and add the quantities used from the second workbook table into a column in the first workbook.

Vlookup seemed to work except that I get n/a in the rows that don't match which is not visually very pretty and I couldn't work out how to get rid of those
I tried to use the MS suggested Index with embedded Match but couldn't make any sense of it and it didn't seem to like working across workbooks.

Any help/pointers gratefully received.
Thanks
DK.

 

[DataKnight]

Think I've sorted it now.....

=IF(ISNA(VLOOKUP(A4,'[ODBC CSP Products Sold with BOM Movements.xlsx]BOMUse'!$L$24:$M$39,2,0)),0,VLOOKUP(A4,'[ODBC CSP Products Sold with BOM Movements.xlsx]BOMUse'!$L$24:$M$39,2,0))