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