Skip to main content
3 of 6
add pictures

Google Spreadsheet - If a string is contained in a row return 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.

Can anyone help me?