Is there a formula that I could use that will return a flag based on the values I dictate are most important? I am trying to draw attention to career days on a basketball spreadsheet. In the summary report I want to flag career points first, then career assists, followed by career rebounds then Season Points, Season Assists, Season Rebounds. Unfortunately, there is only enough space for one flag and the data population is random depending on which was done first. So the order of flags could be CP, SP, SA, CA, CR or it could be SR CR, CA, SP, CP, etc.
If the order of flags was consistent I could just pull the left two or right two charachters first (that is what I did in my first attempt).
The flagging data is located in column 11 of my vlookup. Values again can be listed with all flags, just one flag, or no flags in the following options and are only separated by a space (For example: "SA CA SP CP SR"). Using that example, how could I fish out Career Points "CP"?
Here is the formula I was using:
Formula:Please Login or Register to view this content.
Here is the idea of the formula I want:
Vlookup the flag cell
Find CP if True then "CP"
Else Find CA if True then "CA"
Else Find CR if True then "CR"
Else Find SP if True then "SP"
Else Find SA if True then "SA"
Else Find SR if True then "SR"
Else if Blank then ""
But I don't know how to combine all that into one statement...
Hope that makes sense.
Bookmarks