Do Vlookup from Mutiple file If error using VBA

[ssingh75]

Hi All,

I'he 4 files one is master where data needs to be filled by vlookup and other 3files with input data from where data needs to picked.

e.g.,
Master File

Description</SPAN>	Jan</SPAN>	Feb</SPAN>	Mar</SPAN>
Chandan</SPAN>
Amar </SPAN>
Sohel</SPAN>
Sameer Jan-2012 Description</SPAN> Qty</SPAN> Price</SPAN> Amt</SPAN> Chandan</SPAN> 32</SPAN> Amar </SPAN> 326</SPAN> Sohel</SPAN> 2365</SPAN> Feb-2012 Description</SPAN> Qty</SPAN> Price</SPAN> Amt</SPAN> Chandan</SPAN> 265</SPAN> Amar </SPAN> 32</SPAN> Sameer</SPAN> 236</SPAN> <TBODY> </TBODY><COLGROUP><COL span=4></COLGROUP> Mar-2021 Description</SPAN> Qty</SPAN> Price</SPAN> Amt</SPAN> Chandan</SPAN> 65</SPAN> Amar </SPAN> 32632</SPAN> Sohel</SPAN> 6532</SPAN> Sameer</SPAN> 656</SPAN> <TBODY> </TBODY><COLGROUP><COL><COL><COL><COL></COLGROUP> First master data will match from sheet1 of itself if any error occur or value =0 thenn it will go the file jan-2012 and search the caption "Amt" and do the vlookup from that file. Hope this is clear. </SPAN> <TBODY>  </TBODY><COLGROUP><COL span=4></COLGROUP> </SPAN>

<TBODY>
</TBODY><COLGROUP><COL><COL><COL span=2></COLGROUP>