VLOOKUP question

[austenr]

Ive got Two workbooks. Need to do a vlookup from one and if a match is found copy over columns O:U to the workbook/worksheet doing the lookup. Or would Match/Index work better?

[offthelip]

If I was doing that I would load the entire sheet from the second workbook into a variant array and switch back to the first workbook and use a double loop search for a match in the appropriate column and copy columns O to U to the spreadsheet from the variant array. Actaally if columns O:u in the target spreadsheet were blank I would define a second variant array as the output and copy to the variant array and then write the variant array to the spreadhseet at the end. ( Much Faster)

[SamT]

Definitely a place for a Macro vs LookUp formulas

[parttime_guy]

Hi Guru's & Master's

I would use this simple Vlookup solution, it is not VBA but works.

Best Regards
parttime_guy