Try it like this:

=IF(ISNA(VLOOKUP(J4,'Tariff Info'!$Q$3:$S$17,2,0)),"",VLOOKUP(J4,'Tariff
Info'!$Q$3:$S$17,2,0))


--
Biff
Microsoft Excel MVP


"
m wrote in message
...
Hi
It said " you have entered to many arguments for this function" at the ""
point. I could email it to you to see?
Thanks Richard

"Sheeloo" wrote:

Try
=ISNA(VLOOKUP(J4,'Tariff Info'!$Q$3:$S$17,2,FALSE),"",VLOOKUP(J4,'Tariff
Info'!$Q$3:$S$17,2,FALSE))

" wrote:

I am having problem trying to get rid of #n/a error when i don't enter
a
value.
Anyone that can help, i would appreachate it.
here is the cells:
50mb £5.00 £5.01
100mb £10.00 £10.01
250mb £25.00 £25.01
#N/A #N/A
#N/A #N/A
#N/A #N/A
And formulae i am using
=VLOOKUP(J4,'Tariff Info'!$Q$3:$S$17,2,FALSE).


Also if anyone know how to add a button to finish processing the deal,
and
print to a templete that would be brill...

Richard