| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I LOOK FOR A NUMBER IN A COLUMN IN A SPREADSHEET?
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HOW DO I LOOK FOR A NUMBER IN A COLUMN IN A SPREADSHEET?
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" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HOW DO I LOOK FOR A NUMBER IN A COLUMN IN A SPREADSHEET?
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" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HOW DO I LOOK FOR A NUMBER IN A COLUMN IN A SPREADSHEET?
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding a number in a column out of an array in another column | Excel Discussion (Misc queries) | |||
| how to get the column number from the corresponding column name denoting initial..??? | Excel Worksheet Functions | |||
| Display missing Part Number if Column A does not match column B | Excel Worksheet Functions | |||
| how i write a number on a column A and see that number on letters. | Excel Worksheet Functions | |||
| Auto number w/ different letter-number combos in same column | Excel Worksheet Functions | |||
Linear Mode
