M Mohandas Member Jan 31, 2018 #1 I Have many sheets which has the brand name and averages. I want data from all sheets into one sheet and sheet name as columns heading can any one help me Regards Mohandas Attachments Book1.xlsx 52.9 KB · Views: 1
I Have many sheets which has the brand name and averages. I want data from all sheets into one sheet and sheet name as columns heading can any one help me Regards Mohandas
B bosco_yip Excel Ninja Jan 31, 2018 #2 Try, In "ALL" sheet B6, formula copied across to D6 and all copied down : =IF($A6="","",IFERROR(1/(1/VLOOKUP($A6,INDIRECT("'"&B$3&"'!A5:B500"),2,0)),"")) Regards Bosco Attachments VlookupMultiSheet.xlsx 58.5 KB · Views: 3
Try, In "ALL" sheet B6, formula copied across to D6 and all copied down : =IF($A6="","",IFERROR(1/(1/VLOOKUP($A6,INDIRECT("'"&B$3&"'!A5:B500"),2,0)),"")) Regards Bosco
