Hi, thanks for the info it worked but when I drag the VLOOKUP function on the master spreadsheet it will not work if the Master code is in a different order to the suppliers spreadsheet if the code is in the same order (same row) on both of the sheets it works fine but if not I get #N/A instead of a number (qty).

Here is a copy of the function on the master -
=VLOOKUP(A2,supplier!A2:B7,2,FALSE)

Thanks !