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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lilith - 20 Aug 2007 22:00 GMT

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

Reply to this Message

T. Valko - 20 Aug 2007 22:34 GMT

Try this:

A1 = some number

=IF(COUNTIF(C:C,A1),ADDRESS(MATCH(A1,C:C,0),3,4),"not found")

Signature

Biff
Microsoft Excel MVP

>i have rma numbers in column C, i only want to look through column, i want
>to
[quoted text clipped - 3 lines]
> 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

Reply to this Message

PCLIVE - 20 Aug 2007 22:37 GMT

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

Reply to this Message

Lyn - 20 Aug 2007 22:38 GMT

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.

> 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

Reply to this Message