Finding a value in a multiple column array and returning column header - Excel 2003

[NairbNam]

Hi guys first post here.

I am attempting to lookup a cell value in a 3 column by 20 row array. Depending on which column the value is found, I would like to return that column's header value.

I think I am making this overly complicated for myself. Basically I need a statement that will perform an Hlookup on three columns but I'm not sure exactly how to do this.

Any help would be appreciated.

Thanks!

 

[Aladin Akyurek]

@ Jaywatch

Would you post a sample along with the desired results?

 

[nr6281]

HI I am looking for something similar,

However with few criteria,

I have Column AQ through Column AZ that returns "TRUE OR FALSE" Based on formulas. Now for example IF AQ = FALSE and AR = TRUE " The lookup should come up with header of Column AR since the check is TRUE.

If any criteria below is a match or mutiple it should come up with the header example AN and AP is a match it should return as AN, AP something like this is this even possible
Below are the criteria.

AN	"FALSE"
AO	"TRUE"
AP	"FALSE"
AQ	"TRUE"
AR	"TRUE"
AS	"TRUE"
AT	"TRUE"
AU	"TRUE"
AV	"TRUE"
AW	"TRUE"
AX	"TRUE"
AY	"TRUE"
AZ	"TRUE"

<colgroup><col><col></colgroup><tbody>
</tbody>