I'm new here and really don't know how to search this question on here to see if it has been answered.
Problem: I am creating a spreadsheet to help create a nightly report.
I have five cells that will determine the output to the report field.
The data in the five cells are either "False" or the text for the report field.
Because the text for the report field can be in any of those five cells, how can I pick the right one out without having to use a huge number of if statements.
I'm thinking an array, but I am having aproblem getting it to work. I'm also thinking I may have to do this in VB, but since I have not learned VB yet....
I'm stumped.
Bookmarks