Excel to return matched value in rows from a column array

debugcn Published at Dev

Marky Mark

Super stumped, I am trying to return the values of column based on the value of a cell found in a number of columns. I have attached an image to better describe what I mean. Table So, I'd like to populate column N with each unique value in column M when it finds the value of cell N1. So in cell N1, return row N4 where LICS was found in the array A4 to M27, what I would expect to see is in column O, I am having a dumb day so any help would be appreciated.

user385793

See if a MATCH is found in that row between columns A:L. If found, return column M from that row. Put this in N4 and drag it down.

=if(isnumber(match(n$1, a4:l4, 0)), m4, "")

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-07-21

Comments

0 comments

From Dev

Related Related

Article

Excel to return matched value in rows from a column array

Excel to return matched value in rows from a column array

Excel - Multiple column search and return value from matched cells

Excel: Find results in column, and then search all matched rows for another value and return sum

Return Multiple Rows from Column Value

how to match a column in jquery for a text match and return another column from matched rows

return max value from panda dataframe as a whole, not based on column or rows

Return rows with maximum value of a column

Excel - Find a value in an array and return the contents of the corresponding column

Excel: return name of column with highest value in a non-continuous array

Return matched array items and remove them from original array

Excel search in Array and return column

Return value in column based on value of two rows?

How to return just the matched elements from a mongoDB array

Excel macro to search for value in a column and return a value on the same row from another column in message box

From array of Object , get array of only matched key value

Count No of column value matched and not matched in SQL

Return rows with duplicate value in column if one of the rows contains specific value

Use sed to replace matched value from associative bash array

Remove multiple items from array based on matched value

Get the value that is not matched with matching element from array with two elements

Using array to enter to rows of a column - VBA/Excel

Excel: match value from an array and return cell value from the same row

Return array based on value of column in source array

excel lookup value on another sheet and return value of another column from that sheet

EXCEL Formula to find a value and return column it is found in

Query to return rows in date range but return only max value of column

Pandas: compare two columns and return matched rows

Excel Find column value in another column and return value next to it

Return multiple rows grouped by a column and named by other column value

Return multiple rows grouped by a column and named by other column value