#### Amosbroker

##### New Member

- Joined
- Mar 26, 2018

- Messages
- 31

First column:

contains my unique ID that is my VLOOKUP value (looking up data from another tab)

Second column:

contains gender referred to in formula that is assessed

Third Column Formula:

VLOOKUP(A2,sixteen,10,FALSE) |

<tbody>

</tbody>

Fourth Column Formula:

IFERROR(IF(AND(B2="Male",C2>40),"High",IF(C2="","Unknown",IF(AND(B2="Female",C2>35),"High","Healthy"))),"Unknown") |

<tbody>

</tbody>

My formula works except for the blank expression. Due to the formula being in the cell, it is not actually blank but appears to be so. How do I incorporate no data = Unknown in to my formula? Right now, the blanks come back as high when assessed through my formula.