| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup function macro
i have a series of tables that i need to select from, Below is a sample of
the if statement i have written. I need to copy this to multiple cells. Is there a way to write a function macro to do the same thing? =IF($O18=5,VLOOKUP(RateSheetDate,Table_PF_G5_T1,4) ,IF($O18=6,VLOOKUP(RateSheetDate,Table_PF_G6_T1,4) ,IF($O18=7,VLOOKUP(RateSheetDate,Table_PF_G7_T1,4) ,IF($O18=8,VLOOKUP(RateSheetDate,Table_PF_G8_T1,4) ,0)))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Integrate a Vlookup function in to a macro | Excel Discussion (Misc queries) | |||
| Specifying cell(s) for Vlookup Function in Macro | Excel Discussion (Misc queries) | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Getting a cell address from Vlookup function in a macro? | New Users to Excel | |||
| Adding a Macro to a VLookup Function | Excel Discussion (Misc queries) | |||
Threaded Mode
