How to return multiple columns using vlookup in Excel?
<p>Let suppose i have 2 tables with below data. I want to return all three columns of a row(each row at a time) of table A, when location of table A found in the locations(look for all locations) of table B using vlookup.
e.g: 
step 1: first location of table A = 1
step 2: look for location 1 in table B.
step 3: If found then return first row of table B.</p>

<p>Please see the below example and expected result.</p>

<p>Table A</p>

<pre><code>Location    Quantity    Amount
  1           10         100
  2           20         400
  3           30         500
  4           40         600
  5           50         700
</code></pre>

<p>Table B</p>

<pre><code>Location    Quantity    Amount
1            30          34
3             4          34
4             5          3454
6            65          565
7            66          76
</code></pre>

<p>Expected result:</p>

<pre><code>Location    Quantity    Amount
1            10         100
N/A         N/A         N/A
3           30          500
4           40          600
N/A        N/A          N/A
</code></pre>

<p>I have been doing this for so long but couldn't find the solution yet.
I have millions of records and cannot do it manually. Your answer would be highly appreciated. Thanks !</p>