stormania Member Mar 3, 2020 #1 Dear Excel Masters In attach data, kindly help how simple formula to vlookup data in another table (yellow), because i use one by one vlookup. Thank you Mast Attachments Data Lookup.xlsx 20.1 KB · Views: 9
Dear Excel Masters In attach data, kindly help how simple formula to vlookup data in another table (yellow), because i use one by one vlookup. Thank you Mast
B bosco_yip Excel Ninja Mar 3, 2020 #2 In "SUB" sheet C5, enter formula and copied down to C10 : =VLOOKUP($A5,'DATA 1'!$A$4:$F$9,MATCH(C$3,'DATA 1'!$A$3:$F$3,0),0) Then, select C5:C10, copy/paste to E5:E10, G5:G10 and I5:I10 Regards Bosco
In "SUB" sheet C5, enter formula and copied down to C10 : =VLOOKUP($A5,'DATA 1'!$A$4:$F$9,MATCH(C$3,'DATA 1'!$A$3:$F$3,0),0) Then, select C5:C10, copy/paste to E5:E10, G5:G10 and I5:I10 Regards Bosco
