Hi

embed your VLOOKUP in a IF(ISNA functions e.g.

=IF(ISNA(VLOOKUP(<<your current values)),"",VLOOKUP(<<your current
values))

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Rao Ratan Singh" wrote in message
...
I m preparing invoice for my company which have multiple sheets like
Customer
List and Pipe Size detail with rate of specific pipe.

I want to locate rate of specific pipe in Invoice. For this purpose I m
using vlookup function but when in that position second row is blank or
same
then it returns #N/A.

I just want only want that it should be returned blank when row of Pipe
detail remain blank.

My worksheet have this type of data.
A B C D E F G
Description No. of Pipes (Qty in Mtr) Total Meter Rate Amount
1 063mm x 4Kg TKT 25 6 150 17.42 2613.00
2 075mm x 4Kg TRN 25 6 150 21.76 3264.00
3 #N/A #N/A107.00

It is creating calculation problem. I just only want a function that can
locate rate of particular pipe and in that condition when next row does
not
have any data that function should be returned blank.

Thanks in Advance.

Rao Ratan Singh