Write your formula in A3 like

=IF(ISERROR(A2),0,VLOOKUP(...))

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"bazza825"
wrote in
message
...

I'm using a IF,ISNA,VLOOPUP string in a cell to obtain a price
from a
seperate sheet.

However, a seperate cell is set to perform a calculation on
this number
that is obtained from the above string.

The problem is that unless the user has entered the required
text to
enable the vlookup to obtain the figure, the other column just
lists
#value! all the way down...

How do i get it to display and empty cell... I suspect that
it's caused
by excel attempting to calculate a result from a formula.. or
it that
incorrect.

To summarise as an example
Cell A1, the user enters a search string
Cell A2, contains a Vlookup to search based on A1
Cell A3, contains a calculation that is to be performed on A2
Problem, Where A1 (and therefore A2) dont contain data, A3
displays
#VALUE!

cheers in advance
barry


--
bazza825
------------------------------------------------------------------------
bazza825's Profile:
http://www.excelforum.com/member.php...o&userid=33241
View this thread:
http://www.excelforum.com/showthread...hreadid=537382