ExcelBanter - What is the spreadsheet function in excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - What is the spreadsheet function in excel (https://www.excelbanter.com/excel-worksheet-functions/45080-what-spreadsheet-function-excel.html)

Tan

What is the spreadsheet function in excel

Hi!
In column, there are some data as
A1: 0001
A2: 0002
..
..
..
A100: 0100

Does it has any function to search (eg:0005) in this column?

Please advise! Thks!

Harlan Grove

"Tan" wrote...
In column, there are some data as
A1: 0001
A2: 0002
.
.
.
A100: 0100

Does it has any function to search (eg:0005) in this column?

You want to use the MATCH function.

All times are GMT +1. The time now is 04:50 AM.