Extracting data - vlookups with closed Sheets

hi there,

You very kindly helped me yesterday and I have seen a post today which is similar to what I need.

I wonder if you might be able to help.

The sheet you sorted for me yesterday needs to get its data from 2 other sheets which are closed.
One is simply copying and pasting but the column order is different on open sheet and some columns are not to be copied. The 2nd closed sheet needs to have some data takens from via a Vlook up.

So IF formula sheet is sheet I wan everything to go to.

CAP listing is where the mojority of the data will come from but as I say it is a different order and with additional data I do not need on my IF sheet.

MATS agreements is the other closed sheet which I will Vlookup the CAP (column D on my IF formula sheet) against whole sheet 1 in MATS aagreements and return the other data i.e. 1's and 0's.(although ideally I just want 1's to come across to save me deleting NA and 0 later.

I am not sure how to attache sample files from here if you can let me know I will do this. I attempted to use a code you posted but I think I have adjusted it wrong.

Many Thanks in advance
Libby