title: VLOOKUP or something like it in R
body: <p>Im very very new to R but i have got so far and i need help The data is for demo only but i need to be able to get the name from the room numbers, I can get it so I get the  then both to display but I just need the Name, in excel i would us vlookup</p>
  <pre><code>| Name     | room number  |
  | -------- | -------------|
  | Bob      | 1            |
  | Jane     | 2            |
  | Mike     | 3            |
  | Second   | 4            |
  
  
  Target = &quot;1&quot;
  find_room &lt;- dplyr::select(.data = bookings,
                          name ,
                          Room_no)
  
  Room_no &lt;- find_id[cheque_number == Target]
  
  Room_no
  </code></pre>
  <p>Any help would
  be great</p>