E
excelrookie
If I have the following data
A B C D E
NY MO IL NJ KS
1 Jim x x x
2 Joe x x x x
3 Amy x x x
4 Jane x x x x
How can I write a function that if I input NY into F1 the answer "Jim, Joe,
Jane" will show up in G1 and also if nothing is in F1 is will be blank?
Thanks
A B C D E
NY MO IL NJ KS
1 Jim x x x
2 Joe x x x x
3 Amy x x x
4 Jane x x x x
How can I write a function that if I input NY into F1 the answer "Jim, Joe,
Jane" will show up in G1 and also if nothing is in F1 is will be blank?
Thanks