match index

Hi all, Hope you guys are well. Please check the attached pic. I need to find out the value of "Stock Code" from "Table 1" to "Table 2". Is there any ways I can do it? Thanks in advance :)

I've got data organised in the following way: 2 first columns are identifiers and the rest of the columns are values by year (a year per column). So I need to summarise it in a different table based on 2 identifiers an by year. So each value in the summary table should match the combination of...

Dear friends I have two excel files 1. master 2. marks There are multiple columns in each file . . now i am creating one more file called combine. my reference column is barcode column in both master & marks file. i want to bring all the data in master file to combine file as well as data...

Help! I have been working on this for hours now, and having no luck... I am trying to allow the user to select an Excel the source workbook, and perform a Two Dimensional lookup to pull that data into a target workbook. There are 5 columns to import data to. The source sheet is "Exactly" the...

Hi, I'm struggling to find a formula to find the respective bonus (under criteria below) from the lookup values if I'm given state, title, and amount below. If the title state under lookup values starts in cell A2, what formula could i use to find the respective bonus if given state, title and...

HI i have a formula of ={IFERROR(INDEX(sheet2!$A$2:$H$500,MATCH(2,(sheet2!$G$2:$G$500=sheet1!$B$3)*(sheet2!$H$2:$H$500=sheet1!$AB$2),0),4)," ")} A3 is the date B3 is the name so it is matching the date and name of a person and returning the data. want it to match that and then look at the...

Hello all, Does anyone know how to adapt the match index formula to pull in 3 exact matches, 1 less than match and 1 greater than match? I am looking for a way to pull in a base price for a product depending on several pieces of criteria along with the quantity amount. I want to pull in the...

Hello, I am attempting to look up only the sales team names from 2 columns of employee names. I will be using a list of Sales Team employee ID numbers as the look up value to identify the sales team. In column 1 is the first and last name separated by a space. In column 2 there are multiple...

Hello there, Basically, I am trying to create an excel sheet that will take in options for a product and generate dimensions, a description, and possible drawings based on those inputs to have consistancy across all users. I was successful with the dimensions and descriptions but am...

Hello! I will try to explain my sheets and formulas I have tried thus far. I am trying to populate the top row of a table using a lookup sheet of various sites. Here is the lookup, the reason for the repeated values in column B is another INDEX/MATCH within my table (which is populating just...

Hello All, So I want to return a text value based on 4 criteria. I can do this with the Index Match function, however I want to concatenate ALL text values found in the column that match the 4 criteria into a single cell seperated by "; ". I desperately need help on this! The data would look...

Hi, I am looking at returning a adjacent value that is 'less than' from an array. In this example I want to return what is in Column A where the value is less than 20. So for instance A B Website 60 Facebook 59 Twitter 47 Email 52 Third Party 10 This would return 'Third Party'. I have...

Is There Short form for this Formula Please, but not VLookup, it's working but very long =IF(INDEX(Sheet2!E5:E12,MATCH(C5,Sheet2!C5:C12,0))=1,"ABC",IF(INDEX(Sheet2!F5:F12,MATCH(C5,Sheet2!C5:C12,0))=1,"BCD",IF(INDEX(Sheet2!G5:G12,MATCH(C5,Sheet2!C5:C12,0))=1,"EFG","")))