Hello,
I am creating a fairly complex spreadsheet which is formulated all over however I am stuck when it comes to a specific formula can someone help?
I have a range of cells that will populate with Text depending on the information processed previously in the sheet, only one cell within a row will be populated at one time. The cells to populate are O5:W5 and depending on the text within a cell within this range I need the text to return into cell X5. There are only 3 different text strings that will populate within the cells and then X5 is conditionally formatted to colour depending on its contents... example below:
<tbody>
</tbody>
At the moment I can get the sheet to return the value into O5 if its populated and nothing if its empty with "=IFERROR(INDEX(O15:W15,MATCH("*",O15:W15,0)),"")" however as I said it will only return the value in O5 and nothing else within the range.
could someone advise a formula that will help me with this problem?
thanks
I am creating a fairly complex spreadsheet which is formulated all over however I am stuck when it comes to a specific formula can someone help?
I have a range of cells that will populate with Text depending on the information processed previously in the sheet, only one cell within a row will be populated at one time. The cells to populate are O5:W5 and depending on the text within a cell within this range I need the text to return into cell X5. There are only 3 different text strings that will populate within the cells and then X5 is conditionally formatted to colour depending on its contents... example below:
Own car | Own car Paid | Own car Outstanding | Other - not to pay | Other Paid | Other Outstanding | Unknown not to pay | Unknown Paid | Unknown Outstanding | Permit Obtained |
PAID | PAID | ||||||||
NO ACTION REQUIRED | NO ACTION REQUIRED | ||||||||
OUTSTANDING | OUTSTANDING |
<tbody>
</tbody>
At the moment I can get the sheet to return the value into O5 if its populated and nothing if its empty with "=IFERROR(INDEX(O15:W15,MATCH("*",O15:W15,0)),"")" however as I said it will only return the value in O5 and nothing else within the range.
could someone advise a formula that will help me with this problem?
thanks