I have found a working solution:
=(VLOOKUP(CONCAT(B10,"-",C10,"-",E10,"-",F10,"-",D10,"-",L10),'Worksheet2'!$G$9:$O$44,MATCH('Worksheet1'!$O$9,'Worksheet2'!$G$9:$O$9,0),FALSE))*N10
Cheers
I have found a working solution:
=(VLOOKUP(CONCAT(B10,"-",C10,"-",E10,"-",F10,"-",D10,"-",L10),'Worksheet2'!$G$9:$O$44,MATCH('Worksheet1'!$O$9,'Worksheet2'!$G$9:$O$9,0),FALSE))*N10
Cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks