L Lasantha Member Sep 7, 2017 #1 Dear All, I need your help to vlookup data from table 2 to table 1. but i need it to different format. I don't need to fill all raws. I just need only for 1st raw. Please see the attached data file. (red color) I have thousands of records. Kindly review and help me if you can. Attachments Data File.xlsx 33.8 KB · Views: 5
Dear All, I need your help to vlookup data from table 2 to table 1. but i need it to different format. I don't need to fill all raws. I just need only for 1st raw. Please see the attached data file. (red color) I have thousands of records. Kindly review and help me if you can.
B bosco_yip Excel Ninja Sep 7, 2017 #2 Try, C4, copied across and down : =IF(COUNTIF($A$4:$A4,$A4)=1,VLOOKUP($A4,$L$4:$O$35,MATCH(C$3,$M$3:$O$3,0)+1,0),"") Regards Bosco Attachments Data File(1).xlsx 13.8 KB · Views: 11
Try, C4, copied across and down : =IF(COUNTIF($A$4:$A4,$A4)=1,VLOOKUP($A4,$L$4:$O$35,MATCH(C$3,$M$3:$O$3,0)+1,0),"") Regards Bosco
