Skip to main content
5 of 6
edited title
ale
  • 52.9k
  • 42
  • 165
  • 314

If a string is contained in a row return the value of the first cell of the row

I've this Google Spreadsheet: https://docs.google.com/spreadsheets/d/1-QV49oKCf58HgLBgC8gJ3gc6IXJZAo2xvh6vPTjY05o/edit?usp=sharing

enter image description here

  • check the row in Sheet1 where the domain in Sheet2 is contained
  • return in Sheet2 the related values from the field USER and IP from that row in Sheet1

So for example Sheet2!B3 and Sheet2!B4 should return user1 and pass1. How to do this?