| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match
I am trying to use one huge list to look up some values on based on another
smaller, seperate list to see if there are duplicates. I keep trying to use a match function but I'm not sure if this is the best one to use? Also every time I try to use a match, if or countif formula and drag it down the cell references increase with every cell I drag it down to is there a way to stop this happening? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Match
Your match range needs dollar signs
=match(a1,B$10:B$100,0) "John Cantrell" wrote: I am trying to use one huge list to look up some values on based on another smaller, seperate list to see if there are duplicates. I keep trying to use a match function but I'm not sure if this is the best one to use? Also every time I try to use a match, if or countif formula and drag it down the cell references increase with every cell I drag it down to is there a way to stop this happening? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need to return next match of table, only finding first match...HEL | Excel Worksheet Functions | |||
| how can we get unique values in match function for same match key. | Excel Worksheet Functions | |||
| MATCH Multiple Criteria & Return Previous / Penultimate Match | Excel Worksheet Functions | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
Linear Mode
