Help with Formula Please (Display text if no value exists)

[Kynan]

I'm trying to calculate a number using multiple cells and the vloopup function (as shown in formula below). If no value exists it's returning "#VALUE!" in the cell, if a value exists then it works fine and gives me the correct number, however whenever no value exists I want it to display "N/A" or "-".

The current formula...
=($C$10/2)/COS($C$11*(PI()/180))*$C$16*VLOOKUP('Data Tables'!A13,'Data Tables'!A15:I22,7)

I have tried;
IF(ISNA(($C$10/2)/COS($C$11*(PI()/180))*$C$16*VLOOKUP('Data Tables'!A13,'Data Tables'!A15:I22,7)),"-",($C$10/2)/COS($C$11*(PI()/180))*$C$16*VLOOKUP('Data Tables'!A13,'Data Tables'!A15:I22,7))
But for some reason can't get it to work...

Any suggestions?

Thanks

 

[jeffreybrown]

Hi Kynan,

Although not a rule here, it is a good practice and appreciated if you post a link to your post in other forum's.

http://www.excelguru.ca/node/7

 

[Kynan]

http://www.excelforum.com/excel-gen...a-please-display-text-if-no-value-exists.html
This question also exists in another forum in the hope to get a quick solution. I hope I haven't inconvenienced anyone

 

[jeffreybrown]

I see you are using 2007.

Try...

IFERROR(value,value_if_error)

Look in Excel help for more info.

 

[Kynan]

Absolute legend. Thanks mate

 

[jeffreybrown]

Glad it worked for you