# In Google Sheets how do I search for a specific value in a column?

I’ve started working with Google Sheets.

I’m looking for a value that I believe exists in a specific column.
I know which column the value exists in.

How do I find the value?

Web Applications Asked by bob.dobbs on December 26, 2020

You want to search for a value in a column range, and return the location of the cell. I couldn't find an appropriate precedent in webapps, so this answer is adapted from Google Spreadsheet Check From What Cell VLOOKUP() Returns. The difference in this case is that the search range does not begin with column A and/or Row#1.

Use this formula: =IFNA(ADDRESS(MATCH($B$1,$D$10:$D$16,0)+$B$6-1,$B$5,1),"No match")

• "$B$1": value to search
• "$D$10:$D$16": range to search
• "$B$6": first row of data
• "$B$5": column number being searched.

Sample

Logic

• MATCH returns the row of the searched value in the search range. Since the search range doesn't necessary begin in row#1, you need to add the actual row on which the search range begins and then subtract one to derive the row on which the searched value exists.
• ADDRESS(row, column, abs) returns the cell address. In this case, the row is derived from "MATCH", and the column is entered manually. abs indicated whether the format should be "A1" or "R1C1", the formula opts for "A1".

Correct answer by Tedinoz on December 26, 2020

## Related Questions

### Checking if a value is within one of many possible ranges

0  Asked on January 24, 2021 by rietty

### Google Sheets: Lookup Value that falls after a Timestamp

0  Asked on January 23, 2021 by user261687

### How do I search a string, and return all values?

1  Asked on January 23, 2021 by y-lin

### Twitter trending list not correct

1  Asked on January 23, 2021 by beth202

### Date-Sensitive Interpolation of Missing Data in Google Sheets

1  Asked on January 18, 2021 by wil

### Emails backed up on external hard-drive, how do I transfer those emails into a new gmail account?

1  Asked on January 17, 2021 by joel-zorrilla

### Can I send support questions to Google via email?

1  Asked on January 17, 2021 by mafu

### How to filter Google Sheets by multiple contains using AND

2  Asked on January 17, 2021

0  Asked on January 16, 2021 by roser-veronica

1  Asked on January 15, 2021 by ananth

### Find or conditional format a column of phone numbers NOT in desired format

3  Asked on January 13, 2021 by genny

### Email forwarding to Gmail and SPF

1  Asked on January 13, 2021 by daunpunk

1  Asked on January 10, 2021 by diane

### Why is my Twitter Page in Arabic?

1  Asked on January 10, 2021 by mariana-beaumont

### How to sort files in folder by date created?

3  Asked on January 8, 2021 by user1306322

### How do I associate a storefront order number with a shopping cart transaction on AliExpress?

0  Asked on January 7, 2021 by zhro

### In Google Ads, a broad match keyword of 3 words doesn’t match a search with a 4th word inserted

0  Asked on January 6, 2021

### How to subtract two columns in Google Sheets query?

1  Asked on January 6, 2021