Re: Match / Index Multiple Columns and copy data

Hi,

This post refers to the question in the following thread:

http://www.excelforum.com/excel-prog...copy-data.html

I have tried to use both of these methods for my data. The second method did not work for me, and I have just realized that the first method doesn't even work for the original dataset. If you compare the 2 methods using the original dataset, you'll see that a large number of the barcodes don't show up with the first method, whereas they do with the second method. This suggests to me that there is something wrong with the formula being used, which is unfortunate for me because the other formula doesn't seem to work for me. If someone could fix the 1st formula I would like to try to use it, otherwise I will post my data and perhaps someone can adapt the second formula to it.

thank you

I can't upload. I received the following message:

Your submission could not be processed because a security token was missing.

If this occurred unexpectedly, please inform the administrator and describe the action you performed before you received this error.

Hi,

I'm not sure if perhaps the files are too big, so I have put them online for you to download. Of course this isn't my data, but if you can help me understand this formula, it should be adaptable to my data, but I haven't been able to figure it out. I tried using the first formula, but as in this dataset, it only seems to work some of the entries, not all of them.

http://www.4shared.com/document/16Cx...irst_meth.html
http://www.4shared.com/document/BISN...econd_met.html