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")

--
Biff
Microsoft Excel MVP


"lilith" <(E-Mail Removed)> wrote in message
news:8063B04D-B149-4027-8E4E-(E-Mail Removed)...
>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

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


--

"lilith" <(E-Mail Removed)> wrote in message
news:8063B04D-B149-4027-8E4E-(E-Mail Removed)...
>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

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
on your column C (which will highlight the entire column) and try searching
just the first few characters of the RMA number when you click Find.

"lilith" wrote:

> 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