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

The VLOOKUP part of the formula is not right. The second element in a VLOOKUP should be a range of cells. I suggest you upload the workbook and add some manually calculated result examples with a note as to how you calculate the result. No doubt we can then advise the correct formula.

susiesc, some members of the forum use the "search" facility to look for an answer to their query before posting it, which is part of the reason that rule # 1 of the forum exists:

1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title. - http://www.excelforum.com/forum-rule...rum-rules.html

This thread has exactly the same title as your thread here: http://www.excelforum.com/excel-form...ror-value.html. When I suggested you start a new thread with your new question, I didn't mean for you to give it the same title as the one you have already posted.

Could you please give this thread an appropriate title.

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:

Please Login or Register  to view this content.

and the Revenue at Break Even is simply

Formula:

Please Login or Register  to view this content.

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