Hey everyone,
Plain and Simple - Looking for some help putting together a formula that will search a range for one of three different values (those values can either be defined, or cell references) then return the first match, then second, then third and so forth.
Reference- I create a schedule weekly that excel has proven to be very helpful in creating, the only downside is that the receiving end of the schedule prefers it in a clean PDF file thus i have a blank Publisher document with a grid table setup that i manual transfer information from excel over to.
I have attached a copy of the worksheet i am trying to put together with this formula, along with an example of the preferred format for the receiving end.
Thanks in advance.
[ATTACH=JSON]{"data-align":"none","data-size":"medium","data-attachmentid":1214608}[/ATTACH]