Hello all,
I'm new on this forum and i would like to ask you for a solution to "my problem" hopefully you will help .
i have 2 worksheets each of them containing a table with number of invoice quantity and currency, the table from the first worksheet was modified by deleting some rows and put in the second worksheet.
Unfortunately from the second worksheet somebody deleted a row with currency values and now i have to find out a way to put back the currency for each invoice.
Below is a small example column A number of invoice B quantity C currency
<table style="border-collapse: collapse; width: 162pt;" width="215" border="0" cellpadding="0" cellspacing="0"><col style="width: 62pt;" width="82"> <col style="width: 38pt;" width="51"> <col style="width: 62pt;" width="82"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl66" style="height: 12.75pt; width: 62pt;" width="82" height="17">69110469</td> <td class="xl66" style="width: 38pt;" width="51">800</td> <td class="xl67" style="width: 62pt;" width="82"> 1.548,00 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl66" style="height: 12.75pt;" height="17">69110469</td> <td class="xl66">600</td> <td class="xl67"> 1.515,20 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl66" style="height: 12.75pt;" height="17">69110466</td> <td class="xl66">180</td> <td class="xl67"> 1.823,40 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl66" style="height: 12.75pt;" height="17">69110466</td> <td class="xl66">280</td> <td class="xl67"> 1.825,20 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl66" style="height: 12.75pt;" height="17">69110463</td> <td class="xl66">200</td> <td class="xl67"> 605,23 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl66" style="height: 12.75pt;" height="17">69110462</td> <td class="xl66">400</td> <td class="xl67"> 1.709,04 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl66" style="height: 12.75pt;" height="17">69110467</td> <td class="xl66">120</td> <td class="xl67"> 867,84 </td> </tr> </tbody></table>The problem is that as you can see i have invoices with the same number the only solution i see is to compare the number of invoice and quantity from the second worksheet with this one and to return the corresponding currency value in a new column.
Could you please help with proper formula or with an advice.
Thank you
I'm new on this forum and i would like to ask you for a solution to "my problem" hopefully you will help .
i have 2 worksheets each of them containing a table with number of invoice quantity and currency, the table from the first worksheet was modified by deleting some rows and put in the second worksheet.
Unfortunately from the second worksheet somebody deleted a row with currency values and now i have to find out a way to put back the currency for each invoice.
Below is a small example column A number of invoice B quantity C currency
<table style="border-collapse: collapse; width: 162pt;" width="215" border="0" cellpadding="0" cellspacing="0"><col style="width: 62pt;" width="82"> <col style="width: 38pt;" width="51"> <col style="width: 62pt;" width="82"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl66" style="height: 12.75pt; width: 62pt;" width="82" height="17">69110469</td> <td class="xl66" style="width: 38pt;" width="51">800</td> <td class="xl67" style="width: 62pt;" width="82"> 1.548,00 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl66" style="height: 12.75pt;" height="17">69110469</td> <td class="xl66">600</td> <td class="xl67"> 1.515,20 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl66" style="height: 12.75pt;" height="17">69110466</td> <td class="xl66">180</td> <td class="xl67"> 1.823,40 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl66" style="height: 12.75pt;" height="17">69110466</td> <td class="xl66">280</td> <td class="xl67"> 1.825,20 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl66" style="height: 12.75pt;" height="17">69110463</td> <td class="xl66">200</td> <td class="xl67"> 605,23 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl66" style="height: 12.75pt;" height="17">69110462</td> <td class="xl66">400</td> <td class="xl67"> 1.709,04 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl66" style="height: 12.75pt;" height="17">69110467</td> <td class="xl66">120</td> <td class="xl67"> 867,84 </td> </tr> </tbody></table>The problem is that as you can see i have invoices with the same number the only solution i see is to compare the number of invoice and quantity from the second worksheet with this one and to return the corresponding currency value in a new column.
Could you please help with proper formula or with an advice.
Thank you