I have one sheet with a list of phone extensions in which some have names associated with them and some do not. I am trying to use a function to display one the extensions with names onto another sheet, but I can't wrap my head around the correct formula. I've tried to use the
isblank function or the
len function, but it doesn't seem to work the way I want. If anyone has any advice on how to make this work without using dozens of if statements, I would appreciate the help.
Here is a link to a practice sheet I am using (Edited to a public sheet): https://docs.google.com/spreadsheets/d/e/2PACX-1vQz4seYTcXraVkjMI2FJrLu0xRfdTEc6Fef-OESWbKwuPw_HHu4gy4Dyzk_4HvVQQbXeW5Hjbhhf5KO/pubhtml