| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using worksheet functions INDEX and MATCH within a macro
I would like to use a worksheet function in a macro. This is how I would do
it if I were entering it straight into a cell: =INDEX(range1,MATCH(F1,range2,0)) Can anyone tell me how I would enter it into the macro? The F1 would change to "cboProductSelect.Value", but other than that it should be simple, right? *hopeful* I found this reference, but haven't managed to get it working by trying to follow the guidelines as my formula has too many differences: http://msdn.microsoft.com/library/de...HV05205786.asp |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| INDEX and MATCH functions | Excel Worksheet Functions | |||
| Index and Match functions I think | New Users to Excel | |||
| Using Index & Match functions to find data on separate worksheet. | Excel Worksheet Functions | |||
| How do I use the Match and Index functions to look up a value tha. | Excel Worksheet Functions | |||
| Using Index and Match functions to lookup data in another worksheet | Excel Programming | |||
Threaded Mode
