# Help With a Formula

#### OdysseusVII

##### New Member
I'm not sure if this is even possible but I'm trying to populate a series of different answers depending on the value of previous cells. The different formulas are below, but I would need any given cell in the 5th column to be able to return any of these four answers based on the previous 4 cells. Right now we are populating the 5th column manually and it is hugely time consuming.

 1 #N/A 1 1 Complete 1 #N/A #N/A #N/A No Cert #N/A #N/A #N/A #N/A Not Started 1 #N/A 1 #N/A Not Compliant

<tbody>
</tbody>

### Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Hi,

You don't actually give the criteria, though I presume it's based on the number of 1s in a given row:

=INDEX({"Not Started";"No Cert";"Not Compliant";"Complete"},1+COUNTIF(A1:D1,1))

You also don't mention what should be the result if all four cells contain 1s, so I presume this is not a possibility.

Regards

Replies
5
Views
630
Replies
0
Views
335
Replies
11
Views
3K
Replies
1
Views
642
Replies
4
Views
349

1,203,644
Messages
6,056,525
Members
444,872
Latest member
agutt

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back