Vlookup function macro

[Jack]

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))))

 

[Elkar]

You may not need a macro. See if this works for you:

=VLOOKUP(RateSheetDate,INDIRECT("Table_PF_G"&$O18&"_T1"),4)

The INDIRECT function allows you to create a dynamic range reference based
upon the value in cell O18.

HTH
Elkar

 

[Jack]

Works great - Thanks

You may not need a macro. See if this works for you:

=VLOOKUP(RateSheetDate,INDIRECT("Table_PF_G"&$O18&"_T1"),4)

The INDIRECT function allows you to create a dynamic range reference based
upon the value in cell O18.

HTH
Elkar