Improved question

Source Link

edit approved Dec 28, 2021 at 1:39

103
4

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

I would like to:

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 forFor example Sheet2!B3 and Sheet2!B4 should return user1 and pass1. How to do this?

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

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?

I have a Google Spreadsheet:

I would like to:

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

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

Bumped by Community user

occurred Jan 19, 2018 at 0:58

Bumped by Community user

occurred Dec 20, 2017 at 0:46

Bumped by Community user

occurred Nov 19, 2017 at 23:57

Bumped by Community user

occurred Oct 20, 2017 at 23:43

Bumped by Community user

occurred Sep 20, 2017 at 23:04

Bumped by Community user

occurred Aug 21, 2017 at 21:21

Bumped by Community user

occurred Jul 22, 2017 at 20:35

Bumped by Community user

occurred Jun 22, 2017 at 20:09

Bumped by Community user

occurred May 23, 2017 at 19:45

Bumped by Community user

occurred Apr 23, 2017 at 19:37

Tweeted twitter.com/StackWebApps/status/845851693271191556

occurred Mar 26, 2017 at 4:15

Bumped by Community user

occurred Mar 24, 2017 at 19:11

Bumped by Community user

occurred Feb 22, 2017 at 18:24

Bumped by Community user

occurred Jan 23, 2017 at 18:05

Bumped by Community user

occurred Dec 24, 2016 at 16:42

Bumped by Community user

occurred Nov 24, 2016 at 16:16

Bumped by Community user

occurred Oct 25, 2016 at 15:35

Bumped by Community user

occurred Sep 25, 2016 at 14:42

Bumped by Community user

occurred Aug 26, 2016 at 12:51

edited title

Link

edited Jul 27, 2016 at 10:45

ale

52.9k
42
165
314

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

Bumped by Community user

occurred Jul 26, 2016 at 22:57

Bumped by Community user

occurred Jun 26, 2016 at 22:03

deleted 4 characters in body; edited title

Source Link

edited May 27, 2016 at 21:31

user79865

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

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 How to do this?

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

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?

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

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?

add pictures

Source Link

edited May 27, 2016 at 17:03

fasttrackx

31
3

Loading

Stack Exchange Network

Return to Question

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

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

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

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