HOW DO I LOOK FOR A NUMBER IN A COLUMN IN A SPREADSHEET?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have rma numbers in column C, i only want to look through column, i want to
type in the rma number when i receive it and the spreadsheet says here it is
line whatever....
i just can not seem to get it to look for the number i type in and need to
look for in column c...please help, thank you
 
Try this:

A1 = some number

=IF(COUNTIF(C:C,A1),ADDRESS(MATCH(A1,C:C,0),3,4),"not found")
 
You could do something like this.
With your typed RMA number in D1, enter this formula in another cell.

="Row " & MATCH(D1,C:C,0)

HTH,
Paul
 
First of all, if you place your mouse in one of the cells, is it an actualy
RMA number in the cell or is it a formula? If it is an actual number, click
 
Back
Top