Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Mach
How can I match one number from certain column to the exact number in second
column xls |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Mach
"Dividend" wrote in message
... How can I match one number from certain column to the exact number in second column xls It would help you if you could spell! The word is "match" and you can find it in Help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Mach
assume that the number you wish to match is in cell A1 and the list of
numbers to try to find it in is in column B, from B1 through B100. =MATCH(A1,B1:B100,0) or =MATCH(A1,B:B,0) will return the position of the first place in column B where an exact match to the number in A1 is found. If a match is not found, these formulas would return "#N/A" error. Excel Help for MATCH will tell you about other options to use for the ",0)" portion of the formula. It also works for text as well as numbers. to deal with the no-match #N/A error, you can write the formula like this: =IF(ISNA(MATCH(A1,B1:B100)),"No Match",MATCH(A1,B1:B100)) or even as =IF(ISNA(MATCH(A1,B1:B100)),"",MATCH(A1,B1:B100)) "Dividend" wrote: How can I match one number from certain column to the exact number in second column xls |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup and mach | Excel Discussion (Misc queries) | |||
What is the formula? If A:A is "1" AND B:B is "MACH: SUM F:F | Excel Discussion (Misc queries) |