How to get excel column name dynamically?

[bodlela]

Hi all

I using the below formula on Excel: =IF(AND(Sheet1(2)!$A$2=Sheet5!$A$2,$D$1=Sheet5!$B2),Sheet5!$C2,"") Where is $D$1, 'D' refers to the column letter. I would like to get it dynamically. I tried to use =IF(AND(Sheet1(2)!$A$2=Sheet5!$A$2,CHAR(64+COLUMN())&1=Sheet5!$B2),Sheet5!$C2,"") but it is not working

Please advice

 

[SkipVought]

Hi,

This is not a VBA question: rather formu68 question.

Please use examples of data to illustrate WHAT you are attempting, rather than telling us HOW you think it ought to be done.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}