How to retrieve column header based on lookup

[murtaza88]

Hi,

Can you help me find a way to return the column header from multiple columns by looking up a value in another column?

So basically i want to fill-up the Column "N" by the names in the columns F, I and L by looking up the M column and finding the matching values in F, I and L columns.

Somebody please help me :)

[#2 · Accepted solution]

@murtaza88 Hi. I would in this case suggest SWITCH;

N2 =SWITCH(M2,F2,F$1,I2,I$1,L2,L$1)

[#3]

@bosinander thanks for your help.. it works for me :)

[#4]

@murtaza88 Good. You're welcome :)

[#5]

Hi @bosinander .. i needed help in also pulling up the header name of the 2nd lowest price in the next column. can that be done too?

[#6]

@murtaza88 

Repeat the values in a contiguous range, column P to R.

Find the 2nd smallest value;

=SMALL(P2:R2;2)

Repeat the SWITCH in column T.

[#7]

@bosinander I tried to do it myself by copying your SWITCH formula but it gives a wierd problem. it gives an error only where "CAP Net" column header is supposed to be retrieved.

[#8]

@murtaza88 Hi - You were quite close :) but I fixed it as a table and included the formulas as column formulas on the first sheet.

Using the tables column names may make it easier for you, being familiar with the table.