| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
finding & looping
I am trying to write a macro that looks down a certain column for the word
"day" if it finds it, it then looks through a column of other data for the word "day" and pastes it into my current cell. If it doesnt not say "day" it just equals the cell above it. =IF(RIGHT(B42,6)="day",VLOOKUP(B42,Index!$A$4:$H$5 03,6)," ") kinda what im going for. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looping through 2 workbooks | Excel Discussion (Misc queries) | |||
| Not Looping | Excel Discussion (Misc queries) | |||
| Looping | Excel Discussion (Misc queries) | |||
| looping trouble | Excel Discussion (Misc queries) | |||
| looping question | New Users to Excel | |||
Hybrid Mode
