|
-
Nov 8th, 2012, 07:12 PM
#1
Thread Starter
Frenzied Member
 pulling sq column data in brandmaster table
hi friends,i want to pull sq for that specific brand from weekly posting table into brandmaster sheet .but when i type ,why it does not show True,false automatically .let me know please . see the attachment also . any help would be highly appreciated Attachment 92995
-
Nov 9th, 2012, 05:36 AM
#2
Re: pulling sq column data in brandmaster table
????
i would believe that vlookup requires the lookup value to be in the rightmost column of the lookup table,
i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next
dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part
come back and mark your original post as resolved if your problem is fixed 
pete
-
Nov 9th, 2012, 11:45 AM
#3
Thread Starter
Frenzied Member
Re: pulling sq column data in brandmaster table
????
i would believe that vlookup requires the lookup value to be in the rightmost column of the lookup table,
Status is not availble in tradingsummarystatus table . but it is available on inh_tradingsummary_status and group_no is available in both table . so what i want i want to pull status column value on tradingsummarystaus table from inh_trad_status. i want to fill the status in first excel sheet because
this column is not available in first sheet .but it is available in 2nd sheet ?. so i think this is lookup value. let me know if i am wrong .
Attachment 93029
Last edited by firoz.raj; Nov 9th, 2012 at 12:30 PM.
-
Nov 9th, 2012, 03:25 PM
#4
Re: pulling sq column data in brandmaster table
this column is not available in first sheet .but it is available in 2nd sheet ?. so i think this is lookup value
that should work fine
i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next
dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part
come back and mark your original post as resolved if your problem is fixed
pete
-
Nov 9th, 2012, 03:47 PM
#5
Thread Starter
Frenzied Member
Re: pulling sq column data in brandmaster table
but it is not working even i did not see true/false automatic by intellisense .so i persure there is something wrong .i manually type there false.
-
Nov 10th, 2012, 03:54 AM
#6
Re: pulling sq column data in brandmaster table
as far as i can see you are looking in the same book/sheet as your lookup value
i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next
dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part
come back and mark your original post as resolved if your problem is fixed
pete
-
Nov 11th, 2012, 02:07 PM
#7
Thread Starter
Frenzied Member
Re: pulling sq column data in brandmaster table
even i am looking a lookup value in right side excel sheet . it is not working let me know please .Attachment 93113
-
Nov 11th, 2012, 03:38 PM
#8
Re: pulling sq column data in brandmaster table
as far as i can see you are looking in the same book/sheet as your lookup value
i see you have fixed that now, but your 3rd parameter is now wrong, should be the column number as you had before
i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next
dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part
come back and mark your original post as resolved if your problem is fixed
pete
-
Nov 11th, 2012, 05:32 PM
#9
Thread Starter
Frenzied Member
Re: pulling sq column data in brandmaster table
i see you have fixed that now, but your 3rd parameter is now wrong, should be the column number as you had before
Group_No is available in both the excel sheet .i simple want brandID & BrandName from Brandmaster to INH_Trad_status
because lookup value is GroupNo in both the excel sheet .but still it is not working .Attachment 93125
-
Nov 12th, 2012, 03:17 AM
#10
Re: pulling sq column data in brandmaster table
vlookup must lookup the first column in the range, so in your example above
probably should be
vlookup(a15, brandmaster.xls!(b2:c78, 2, false)
group in a15, range containing look up table with group in 1st column, 2 for column number to return brandname, in this case sports city
brandID in column A can not be returned by vlookup, as the lookup value would not be in the first column
i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next
dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part
come back and mark your original post as resolved if your problem is fixed
pete
-
Mar 13th, 2013, 06:54 AM
#11
Thread Starter
Frenzied Member
Re: pulling sq column data in brandmaster table
Hi, i have been trying to get barcode from Book12 Sheet .and i want to insert into Barcode column .but always it
say #N/A if there are matching records on the basis of Item.item field is common in both the sheet . let me know
please .see the attachment please Attachment 97625 .
-
Mar 13th, 2013, 03:25 PM
#12
Re: pulling sq column data in brandmaster table
please .see the attachment please
??????
i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next
dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part
come back and mark your original post as resolved if your problem is fixed
pete
-
May 15th, 2013, 03:33 AM
#13
Thread Starter
Frenzied Member
Re: pulling sq column data in brandmaster table
Hi , i am generating some report and converting into csv by Toad Utility .and when i creating Lookup table from the
Csv file .i am able to getting data into other excel sheet . but when i am converting into excel by Toad Utility .
then vlookup is not working .and it says N/A into target sheet while vlookup . let me know please is there any formating issue also . any help would be highly appreciated.
-
May 15th, 2013, 07:03 AM
#14
Re: pulling sq column data in brandmaster table
post a sample of the converted csv
i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next
dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part
come back and mark your original post as resolved if your problem is fixed
pete
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote