Skip to main content
Web Applications

Return to Question

Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
added 95 characters in body
Source Link
user135384
user135384

I'm trying to link names from one sheet to another, I know how I would do that normally but I want to add in some points that need to be true to be able to be placed in that cell.

http://prntscr.com/hpj9ym This This is the part where I'd fill in the names manually:

http://prntscr.com/hpjahk Thisfill in manually

This is where the name would have to be moved in to automatically,

automatic

Sheet name 1 is named "Roster" 2nd. Second Sheet name is "Kavala"

I need a name of department "Kavala" and rank has to be Chief Inspector and if that's true then their name should be put on the 2nd sheet.

I'm trying to link names from one sheet to another, I know how I would do that normally but I want to add in some points that need to be true to be able to be placed in that cell.

http://prntscr.com/hpj9ym This is the part where I'd fill in the names manually

http://prntscr.com/hpjahk This is where the name would have to be moved in to automatically,

Sheet name 1 is named "Roster" 2nd Sheet name is "Kavala"

I need a name of department "Kavala" and rank has to be Chief Inspector and if that's true then their name should be put on the 2nd sheet.

I'm trying to link names from one sheet to another, I know how I would do that normally but I want to add in some points that need to be true to be able to be placed in that cell.

This is the part where I'd fill in the names manually:

fill in manually

This is where the name would have to be moved in to automatically,

automatic

Sheet name 1 is named "Roster". Second Sheet name is "Kavala"

I need a name of department "Kavala" and rank has to be Chief Inspector and if that's true then their name should be put on the 2nd sheet.

deleted 68 characters in body; edited title
Source Link
pnuts
pnuts
  • 17.8k
  • 5
  • 54
  • 103

Need some help with google spreadsheets, trying Trying to reference data from another sheet to another

So basically I'm tringtrying to link names from one sheet to another, I know how I would do that normally but I want to add in some points that need to be true to be able to be placed in that cell.

http://prntscr.com/hpj9ym This is the part where I'd fill in the names manually

http://prntscr.com/hpjahk This is where the name would have to be moved in to automatically,

Sheet name 1 is named "Roster" 2nd Sheet name is "Kavala"

I need a name of department "Kavala" and rank has to be Chief Inspector and if that's true then their name should be put on the 2nd sheet.

If anyone could help me out being able to link those

Need some help with google spreadsheets, trying to reference data from another sheet to another

So basically I'm tring to link names from one sheet to another, I know how I would do that normally but I want to add in some points that need to be true to be able to be placed in that cell.

http://prntscr.com/hpj9ym This is the part where I'd fill in the names manually

http://prntscr.com/hpjahk This is where the name would have to be moved in to automatically,

Sheet name 1 is named "Roster" 2nd Sheet name is "Kavala"

I need a name of department "Kavala" and rank has to be Chief Inspector and if that's true then their name should be put on the 2nd sheet.

If anyone could help me out being able to link those

Trying to reference data from another sheet to another

I'm trying to link names from one sheet to another, I know how I would do that normally but I want to add in some points that need to be true to be able to be placed in that cell.

http://prntscr.com/hpj9ym This is the part where I'd fill in the names manually

http://prntscr.com/hpjahk This is where the name would have to be moved in to automatically,

Sheet name 1 is named "Roster" 2nd Sheet name is "Kavala"

I need a name of department "Kavala" and rank has to be Chief Inspector and if that's true then their name should be put on the 2nd sheet.

Source Link
Sil van den Nieuwendijk
Sil van den Nieuwendijk
  • 1

Need some help with google spreadsheets, trying to reference data from another sheet to another

So basically I'm tring to link names from one sheet to another, I know how I would do that normally but I want to add in some points that need to be true to be able to be placed in that cell.

http://prntscr.com/hpj9ym This is the part where I'd fill in the names manually

http://prntscr.com/hpjahk This is where the name would have to be moved in to automatically,

Sheet name 1 is named "Roster" 2nd Sheet name is "Kavala"

I need a name of department "Kavala" and rank has to be Chief Inspector and if that's true then their name should be put on the 2nd sheet.

If anyone could help me out being able to link those