What are the ways around, when the cell reference does not exist

[helpme20]

I have a workbook setup with 3 worksheets. Products, Floor, Cost

some products have two different values. XYZ product my a floor cost that is found on the Floor Cost worksheet, while the same XYZ product will have a real cost that is found on the Cost worksheet.

I have the formula below that toggles between the two values, based on the user changing the drop down list cell between "Floor Cost" and "Real Cost".

=IF($C$1="Floor Cost",INDIRECT(VLOOKUP(C11,$C$284:$D$328,2,FALSE)&"floor"),VLOOKUP(G11,INDIRECT(VLOOKUP(C11,$C$284:$D$328,2,FALSE)&"table"),10,FALSE))

Not all products have a "Floor Cost" value on the Floor worksheet, but all products do have a "Real Cost" listed on the "Cost" worksheet.

My question is: How can I alter the formula above to return the "Real Cost" value when the cell does not exist when the user is in the "Floor Cost" drop down?

 

[sheetspread]

Use an IF/ISERROR if the cell doesn't exist, but I think you mean it's blank, so if = 0.