Get instant live expert help with INDEX Function in Excel

I need assistance with an index formula, to move over a priority code, associated with a store number on one sheet to another. On sheet "MMC data," you will see in column "I" there is a store priority code. On both sheets, column A (store number) matches the data on both sheets. Please index the store priority (column I) on "MMC data" by matching column A on both sheets (store number).

I need to INDEX the "Store Priority" from "MMC Data" tab (column H) to "Walmart Stores TV" tab to column C labeled "Store Priority."

INDEX MATCH MATCH function is not working. Can not find the lookup value but i know that it is there and exists. I have tried the trim function to get rid of any necessary spaces but no luck. All i get is #N/A.

I am trying to use an INDEX MATCH MATCH function to pull data from one of my sheets however nothing I do seems to work

Hi guys, I have a big database that I want to connect to another database. I want to get a value for from one of the databases into the first, but only if the name and the builder of the particular vessel is the same. I am trying with vlookup, index and match, but I can not get it to work. Can you help me?

I am trying to create a formula that skips a column; For example; The formula in cell B4 is =sum(cash flow!CD5:CD16) the formula in cell C4 would be =sum(cash flow!CE5:CE16) I believe I need to use the Index function to do this but I am not sure how to write it

I am uploading stock index performance data by month from an inflexible data base. The months are represented by text...i.e.,, "Sep-17". My Fund Performance data is uploaded as "current month" and only further identified by a second column containing the date, i.e., 9/30/2017. I need to be able to somehow match the 9/30/2017 to the "Sep-17". Any thoughts?

Hello, I am trying to create a csv generator which will look up all the information from background speadsheets and bring it up in the necessary fields. I am not sure why but when I change the column index number (where the pricing info is), it does not want to work, can anyone help please? My formula is below: To look up Description =IF(LEN(E16)<1,IF(LEN(G16)<1,"",VLOOKUP(G16,MATCODE1,2,FALSE)),"") To look up Price =IF(LEN(G16)<1,IF(LEN(J16)<1,"",VLOOKUP(J16,MATCODE1,5,FALSE)),"")

I have to know more about index and match. Moreover if formula where in i have to calculate the incremental achievement and where in bonus to be given. Example For 100% achievement -Rs 1000 ,For 110% Achievement -Rs 5000 only on incremental increase and on 120% achievement again on incremental increase Rs 10000

I need to INDEX the State, County and Zip to autofill in where it is blank. Example: Column B, Row 3 has "Newport Beach" with a Blank County in Column E, Row 3. But Column B, Row 31 has "Newport Beach" with "Orange" in Column E Row 31.