=vlookup
 

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

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

Can't be certain based on the post, & you don't show your expression as it is
currently written, but my guess would be that the Table_array argument of
your vlookup is _not_ using Absolute References. Something like;

A1:G50 which should read as $A$1:$G$50

That will prevent the ref. from changing when copied down to additional rows.

HTH |:)

"Rao Ratan Singh" wrote:

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