  Get instant live expert help with Excel or Google Sheets “My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.

# How to Use INDEX and MATCH Together in Google Sheets

We can use a formula that is based on the INDEX and MATCH functions to lookup a value in a table in a Google Sheet. Unlike in excel where the result is entered with CRTL+SHIFT+ENTER, the result is entered with the enter key only for Google Sheets. The steps below will walk through the process. Figure 1- How to Use INDEX and MATCH Together in Google Sheets

## General Formula

`=INDEX(range1,MATCH(A1,range2),0))`

• Range1 is the array of values from which INDEX returns the final result
• Range2 is the array of values that help INDEX to identify the position of the value to return

## Formula

INDEX RETURNS HEIGHT:` =INDEX(D4:D10,MATCH(H3,B4:B10,0))`

INDEX RETURNS COST: `=INDEX(E4:E10,MATCH(H3,B4:B10,0))`

## Setting up the Data

We will use the INDEX and MATCH functions to get the Height and the Cost of the A grade item in figure 2. We must note that where there are similar values that could be returned, INDEX returns the first matching value. Figure 2 – Setting up the Data

## Lookup HEIGHT with INDEX and MATCH Functions

• We will click on Cell H4
• We will insert the formula below into Cell H4
`=INDEX(D4:D10,MATCH(H3,B4:B10,0))`
• We will press ENTER Figure 3- Result for Lookup of Height with INDEX and MATCH functions

## Lookup COST with INDEX and MATCH Functions

• We will click on Cell H5
• We will insert the formula below into Cell H5
`=INDEX(E4:E10,MATCH(H3,B4:B10,0))`
• We will press ENTER Figure 4- Result for Lookup of Cost with INDEX and MATCH functions

## Explanation

INDEX RETURNS HEIGHT:` =INDEX(D4:D10,MATCH(H3,B4:B10,0))`

In this formula, the MATCH function looks for the value of Cell H3 in Range B4:B10. 0 signifies that we require an exact match. The MATCH FUNCTION returns the position 1 and 3. Because INDEX returns the first matching value, TALL is returned as the height.

## Instant Connection to an Expert through our Excelchat Service

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

Solution examples index and match with duplicates. I need to use another column as a reference, so my return value has two match the value of two things for it to return
Solved by E. H. in 60 mins Hello, I have a big spreadsheet in which I need to know how many patients came in each month based on provider. I am using the following formula but I still get the N/A error. =INDEX('No Show Appts Data'!D:E, MATCH(1, 'No Show Appts Data'!D:D='No Shows Data'!M2)*('No Shows Data'!E:E='No Shows Data'!N1),0)) No Show Appts Data is the name of the sheet where Column D is Month Year of date in question and Column E is the provider. No Shows Data is the sheet where I am making all the formula calculation where Column M is Month and Year and Column N is the provider in question and therefore M2 is the month in question and N1 the provider in question. How do I fix this error? Thanks
Solved by F. H. in 40 mins I need to find an INDEX function that will convert the Call Day (a number 1-7) to the actual weekday found in row 1 of the DayofWeek named range. I don't know if I'm supposed to use the MATCH function as well or not.
Solved by D. D. in 11 mins I have two columns with names and a third one with email addresses. For every name that matches, I need to copy the email address to an empty column next to the matching name. .
Solved by E. U. in 15 mins help with INDEX(IndexArea,MATCH(\$M\$5,MatchRows,0),MATCH(\$M\$6,MatchColumns,0))
Solved by Z. Y. in 12 mins 