Need help in excel formula
<p><a href="https://i.stack.imgur.com/TdNvw.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/TdNvw.jpg" alt="enter image description here"></a></p>

<p>1) I have two tables.  1st table contains data for more then 20,000 rows and 2nd table I already have the following columns details i.e. Region, Item, Number and I just have to get the Total value of the product from the 1st table  </p>

<p>2) There are two types of prices in the 1st table .  One is Retail Price and Another one is a Wholesale price</p>

<p>3) In each of the regions Rep, Item and Numbers are same in most of the cases, but the Total price is different</p>

<p>4) I am able to get the Total price details in 2nd table through vlookup formula (After concatinating the following columns i.e. Region, Item and Number from both the tables) wherever there is an account number for retail price</p>

<p>5) Currently I am manually updating "Total Price" details in 2nd table for Wholesale price which is taking lot of time.  </p>

<p>Is it possible to build a formula to get the wholesale price details in the 2nd table, since there are more then one account number, but the price is same</p>