V-lookup function on Primary key with multiple variations

Hello Experts ,   I have 2 tables in my workbook. Table A has below columns. In Table A I need name of customers from Table B on the basis of Invoice Number.   TABLE A Invoice no. Qty Amo...