Forum Discussion
Returning a text value from an array
I have an array. and want to search a specific column for a value greater than 0 in the array. if i find a value greater than 0 i want to return the text entered in a different column of the array....
Hi,
It could be like
=IFNA(INDEX(<category column>, MATCH(<number>,<label column>,0)),"")
Thank you
That did not work for what I wanted it to do
There is a similar case that based on a selected row header (yours is column header) to get the list of data in a row (yours is column), and then return the column headers of the data (yours is to return row header).
If you attach your sample as Excel file we could give you concrete formula for that
I have attached an excel file that may explain better
