Printable View
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
????Quote:
see the attachment also
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 becauseQuote:
????
i would believe that vlookup requires the lookup value to be in the rightmost column of the lookup table,
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
that should work fineQuote:
this column is not available in first sheet .but it is available in 2nd sheet ?. so i think this is lookup value
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.Quote:
that should work fine
as far as i can see you are looking in the same book/sheet as your lookup value
even i am looking a lookup value in right side excel sheet . it is not working let me know please .Attachment 93113
i see you have fixed that now, but your 3rd parameter is now wrong, should be the column number as you had beforeQuote:
as far as i can see you are looking in the same book/sheet as your lookup value
Group_No is available in both the excel sheet .i simple want brandID & BrandName from Brandmaster to INH_Trad_statusQuote:
i see you have fixed that now, but your 3rd parameter is now wrong, should be the column number as you had before
because lookup value is GroupNo in both the excel sheet .but still it is not working .Attachment 93125
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
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 .
??????Quote:
please .see the attachment please
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.
post a sample of the converted csv