Use IFERROR function to display a blank cell instead of a error value

Hi,

You have a circular reference with your current approach, which is not usually to be recommended. But surely your Break Even units in C18 is simply

Formula:

=MonthlyExpenses/(PricePerUnit-CostPerUnit)

and the Revenue at Break Even is simply

Formula:

=C18*PricePerUnit

Not sure why you need to worry about VLOOKUPs since the table is only there to generate the chart data.