What is the spreadsheet function in excel

T

Tan

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!
 
H

Harlan Grove

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?
Click to expand...

You want to use the MATCH function.
 
Top