Use mycolumn name dynamically in formula

[gammaman]

I have an excel report which I am creating Via VBA Macro, with several columns that have calculations on them. The problem is that there are times when my report will have additional or fewer columns. This is causing the fromulas to break since the columns are shifting. So essentially, I never really know where the columns will end up and I don't want to rewrite the formulas every time.

Say I have the following formula

=IF(ISBLANK(Q2),0,IF(Y2=""T"",0,1))

How can I write this to be someting like

=IF(ISBLANK("Wherever header column" = "ABC"),0,IF("Whever column header is "XYZ" =""T"",0,1))

[zbor]

Upload example workbook with your input(s) and desired output.
Make sure to avoid all private informations.

[gammaman]

I am unable to upload at this time however here is an example.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

As seen here, the second example has an additional field. It is the same for my report. Sometimes there are additional fields.

Therefore if I want to do something based on IDNUMBER, I cannot simply say

If (C2 = "122345") ...

because the forumla will not work in the second example. I want to instead be able to say

IF (IDNUMBER = "12345") .... this way it does not matter what column IDNUMBER is in, the formula will always work.

[zbor]

You can make FOR loop.