How do I look up something and combine data from three individual workbook or
excel file?
like sheet1, sheet2, and sheet3
I know the standard vlookup formula =vlookup(A1,data$a$1:$C$6500,2,false),
but this only combine two spreadsheet. I my case I need to do combine three
or more worksheets or files.
Thanks your assistance in advance