Home |
Search |
Today's Posts |
#1
|
|||
|
|||
=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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|