How to get data from columns with headers using macros

[Melzebu]

Hi everyone,

I have a small question for you:

Let's say I have a table with headers and I'm trying to calculate an average.
I'm using the following macro to calculate it
Sub Average()
'
' Average Macro
'
'
ActiveCell.FormulaR1C1 = _
"=IFERROR(AVERAGEIF('Report'!C[-2],""Severity 1"",'Report'!C[3]),""-"")"
End Sub

but I would like to change 'Report'!C[-2] with the column header "Severity" and 'Report'!C[3] with the column header "FRT".
How can I do that? Are there some "universal" lines I can use in all macros where I need to get data from a specific column with header?

Thank you again for your help.
Cheers

 

[BSALV]

for such basic things, i use the macro-recorder, do the handling and delete all unnecessary noise.
I did this for you and the result was this
ActiveCell.FormulaR1C1 = "=IFERROR(AVERAGEIF(Tabel1[MYA],""severity"",Tabel1[MYB]),""?"")"
so, the tablename and between squares the name of your header

 

[Melzebu]

for such basic things, i use the macro-recorder, do the handling and delete all unnecessary noise.
I did this for you and the result was this
ActiveCell.FormulaR1C1 = "=IFERROR(AVERAGEIF(Tabel1[MYA],""severity"",Tabel1[MYB]),""?"")"
so, the tablename and between squares the name of your header

Thanks BSALV, that really did the work.