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

#### Kynan

##### New Member
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

### Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

#### jeffreybrown

##### Well-known Member
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

#### jeffreybrown

##### Well-known Member
I see you are using 2007.

Try...

IFERROR(value,value_if_error)

#### Kynan

##### New Member
Absolute legend. Thanks mate

Replies
3
Views
54
Replies
11
Views
47
Replies
0
Views
29
Replies
9
Views
143
Replies
2
Views
174