I'm working a spreadsheet and trying to figure out this formula but have had not luck. What I have is a list of people on one sheet, and on the other sheets, I have different offices. I need to have a function that searches the other sheets and, if it finds them on the other sheets, return and past the location.
The list of names is on "Active Lines-Phones" under column F.
The office sheet is "Sheet1". The list of names on that sheet is column A.
If it finds the name from "Active Lines-Phones" column F cell 86 on the list of names from Sheet1 column A, I need it to return the text "Kansas City"
Can someone help me figure out this script?
And if this one is fairly simple, what I'd like it to eventually be able to do it check multiple sheets to see if it can find it on a different sheet.(EG: If it doesn't find the name on Sheet1, it checks Sheet2, then Sheet3 and so on... And if it doesn't find it on any of those, it returns a value of "False" or "?" or something)
Thanks!
The list of names is on "Active Lines-Phones" under column F.
The office sheet is "Sheet1". The list of names on that sheet is column A.
If it finds the name from "Active Lines-Phones" column F cell 86 on the list of names from Sheet1 column A, I need it to return the text "Kansas City"
Can someone help me figure out this script?
And if this one is fairly simple, what I'd like it to eventually be able to do it check multiple sheets to see if it can find it on a different sheet.(EG: If it doesn't find the name on Sheet1, it checks Sheet2, then Sheet3 and so on... And if it doesn't find it on any of those, it returns a value of "False" or "?" or something)
Thanks!
Last edited:
