Trending in Formulas and Functions
-
Change dot color based on date field
I am trying to come up with a formula that will change a RYG symbol to green if the date in another column is within the first 14 days of a month. The symbol column is already set up with the right column type. Thank you for the help!
-
VLOOKUP Formula to pull column data into another sheet
I'm trying to match the "Application" # (Table 1) to the "Application Name" (Table 2) and return the corresponding "Primary Product Family" (Table 2, Column 2) into "Program" (Table 1, Column 1) using the VLOOKUP formula, but I'm receiving some of the information and the other information returns #NO MATCH. I want to match…
-
Formula using Index and Match to reference another sheet only returns first item
I am using an Index/Match formula to lookup a person associated with a specific region. I have a sheet setup as a lookup table named Gift Card Approver with 2 columns: Region and Approver. In my main sheet I have a formula that pulls the region from the current line and uses that to lookup the approver in the Gift Card…