| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using lookup in a VBA procedure
Hello
I am a beginner and I woul like to get the addres of the cell with a date, choosen by lookup, to use its adress to check the date in the adiacent cell so long as it is bigger the a given date. Thank you for your help -- dilettante |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using lookup in a VBA procedure
look at Find in help to get the cell, then use Offset to get the adjacent
cell. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "dilettante" wrote in message ... Hello I am a beginner and I woul like to get the addres of the cell with a date, choosen by lookup, to use its adress to check the date in the adiacent cell so long as it is bigger the a given date. Thank you for your help -- dilettante |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Another way to lookup data | Excel Worksheet Functions | |||
| Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
| Table Lookup | Excel Worksheet Functions | |||
| Lookup function w/Text and Year | Excel Worksheet Functions | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Linear Mode
