alabama

Hello! I've concatenated some cells in order to use VLOOKUP. So for example, I concatenated Oklahoma with Alabama which gives me OklahomaAlabama so when I use VLOOKUP I get the desired result. However, I'm getting results from cells with data such as OklahomaSouth Alabama which I don't need...

Hello! If I use the formula in H2 and bring it down to H7, I get the desired results, unfortunately when it reaches H8 I get the #NUM result. I know that if I change the ROWS(F$2:F8) to ROWS(F$8:F8) I get the required result, but I'm just wondering if there's a way that would do it...

Hi, I have a two long column of data that look like this: B C Alabama AL Alaska AK Arizona AZ my goal is to find and replace the data in column A with the matching data in column C For example if I type Alabama in cell A4 it will...

I'm trying to create a sumifs formula to determine the sales of a state for a certain sku in a timeframe. This is just a subset of the source data. I'll be looking for a few states, but Iowa to start. This info will be populated in another cell. Iowa for sku 2330993 and for this week 201711...