Apply Vlookup formula Alternate Columns throughout Worksheet

Hi

I have two workbooks with over 2000 columns each (but only a couple of hundred rows) of data. Each data point has a unique identifier. I'm using a vlookup function that finds and returns the appropriate value from one workbook to another. My challenge is to apply this formula to all 2000 rows without having to manually retype the formula in each column and auto-filling. E.g. in the workbook, Columns C, E, G etc (every other column) look up the matching value from the reference workbook and returns it to my combo sheet. Need to extend this formula to columns Q, S, U (and so on)

A sample worksheet is attached. I have very limited knowledge with macros and formulae, so any help is much appreciated.


Thanks

Hi Ford

Thanks for the reply. The file uploaded is one of the two workbooks, and I'm importing the data from the second workbook into it.

I can change the formula from vlookup to index/match, but then how do I copy the formula to all the columns without manually cutting and pasting it in each column? I tried to record a macro to do it (see below), but don't know how to loop the macro so it fills in all columns that are blank in the entire sheet.

Please Login or Register  to view this content.