I'll try to explain this as concisely as possible.
I have been given the task of cross-referencing several workbooks and creating a new, more easily-understandable excel document to be distributed internally within the company. It occurred to me that it would go much faster if I could apply a formula to check certain elements against each other and draw out the necessary data from the columns in that manner. To that end, I used VLOOKUP to successfully take the element I wanted from one workbook and insert it into the correct column in the new workbook.
However, because the data I'm cross-referencing in the old workbook is in non-contiguous rows (e.g. H843, H845, H934, etc.) and the rows in the new workbook are contiguous (H5, H6, H7, ...), trying to drag the formula down across the entries in the new workbook doesn't change it at all (at least, I assume it's to do with the non-contiguous/contiguous entries, perhaps it just doesn't work like that across workbooks).
Is there any way to remedy this, or can anyone offer a better solution to this task?
Thanks muchly,
Ajay
I have been given the task of cross-referencing several workbooks and creating a new, more easily-understandable excel document to be distributed internally within the company. It occurred to me that it would go much faster if I could apply a formula to check certain elements against each other and draw out the necessary data from the columns in that manner. To that end, I used VLOOKUP to successfully take the element I wanted from one workbook and insert it into the correct column in the new workbook.
However, because the data I'm cross-referencing in the old workbook is in non-contiguous rows (e.g. H843, H845, H934, etc.) and the rows in the new workbook are contiguous (H5, H6, H7, ...), trying to drag the formula down across the entries in the new workbook doesn't change it at all (at least, I assume it's to do with the non-contiguous/contiguous entries, perhaps it just doesn't work like that across workbooks).
Is there any way to remedy this, or can anyone offer a better solution to this task?
Thanks muchly,
Ajay