title: Vlookup from One Column to Place Values in Multiple Columns
body: <p>I'm trying to use vlookup to return multiple phone extensions for the same room number. Normally, I would be able to accomplish this using vlookup, but it only returns one value from one column. Is there a way I can get vlookup to return multiple values within same column across multiple cells?</p>
  <p><a href="https://docs.google.com/spreadsheets/d/1WK18hdKiHKTwjRTnXzd33UGhx4IxkohC9gVEGxol5Gk/edit?usp=sharing" rel="nofollow noreferrer">In the sample spreadsheet I've provided that you can edit</a>, I have the same room number multiple times in column A within tab titled &quot;Phones&quot; because sometimes there is more than 1 phone in the same room. I'm wanting to use an arrayformula that uses vlookup in tab titled &quot;Users&quot; to bring over each phone for the same room, in columns B and C, titled Phone 1 and Phone 2.</p>
  <p>Thanks for your help!</p>