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
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
Row 10 has leading spaces, remove them.
Then, in A11
=IF(ISNUMBER(MATCH(A$10,$B3:$G3,0)),$A3,"")
Copy down and across
Life's a spreadsheet, Excel!
Say thanks, Click *
Thanks its working fine
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks