Check column header and return value

**nareshkt** · 10-15-2013, 03:54 PM

Hi All,

I have name in column A and column B to column G have multiple plant names if the column name match with the header of the column it should return the column A value

**Ace_XL** · 10-15-2013, 04:16 PM

Row 10 has leading spaces, remove them.

Then, in A11

=IF(ISNUMBER(MATCH(A$10,$B3:$G3,0)),$A3,"")

Copy down and across

**nareshkt** · 10-15-2013, 05:21 PM

Thanks its working fine

Check column header and return value

LinkBack

Thread Tools

Rate This Thread

Display

Check column header and return value

Re: Check column header and return value

Re: Check column header and return value

Thread Information

Users Browsing this Thread

Similar Threads

Using Lookup to Return Column Header or Index Function to return revised pay rate

Return value under column header

Return column header, max value, 2 values same

Way to return a column header value?

Return Column header, if row value is > X

Bookmarks

Bookmarks

Posting Permissions