| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find and match cells
Hello,
I have a list of values in sheet 1, from cell A1 and downwards. The range changes all the time, eg. A1-A10, A1-1000 etc. I want to set up a macro that matches all the values in this column with the A column in sheet 2. If some of the cells matches I want the macro to copy the value in the B column of the same row as the matching cell in sheet 1 and paste it into sheet 2 column B, next to the cell just found. Any sugestions, please? Martin |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find and match cells
Must it be a macro?
Use VLOOKUP to get the data. "Martin" wrote: Hello, I have a list of values in sheet 1, from cell A1 and downwards. The range changes all the time, eg. A1-A10, A1-1000 etc. I want to set up a macro that matches all the values in this column with the A column in sheet 2. If some of the cells matches I want the macro to copy the value in the B column of the same row as the matching cell in sheet 1 and paste it into sheet 2 column B, next to the cell just found. Any sugestions, please? Martin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can find match of one cell from a column of cells? | Excel Discussion (Misc queries) | |||
| Match, Find? | Excel Worksheet Functions | |||
| find all cells that match and use in an index/vlookup | Excel Discussion (Misc queries) | |||
| Using MATCH to find the 2nd match, not only 1st | Excel Discussion (Misc queries) | |||
| find and match the max | Excel Worksheet Functions | |||
Linear Mode
