thanks for your assistance. Please take a look. Earlier did not work. Thanks, Smriti
On 8/24/11, dguillett1 <dguille...@gmail.com> wrote: > If you didn't solve this, I'll take a look? > > -----Original Message----- > From: Baby Patel > Sent: Thursday, August 18, 2011 8:29 AM > To: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ Need a Formula or Macro > > Hi All, > > Please find the attchement. All these data are here in the zipped > file. You can use price list to find the details. > > > Thanks and regards, > Smriti > > On 8/18/11, dguillett1 <dguille...@gmail.com> wrote: >> It would be very helpful if your data could result in an actual case with >> a >> real example. >> You ask to search for data that does NOT exist. >> >> -----Original Message----- >> From: Baby Patel >> Sent: Wednesday, August 17, 2011 8:08 AM >> To: excel-macros >> Subject: $$Excel-Macros$$ Need a Formula or Macro >> >> Hi Guys, >> >> I need an urgent help . Attached is the excel file for your reference. >> >> Issue : I want the result in the F coulmn of Sheet1. the Sku #from >> Coulmn B of Sheet 1 will be searched in A column of sheet2. If the SKU >> was found then it will check the Currency and Margin (B & C column of >> Sheet 1) with Currency and Price Level ( B & C column of Sheet2). If >> it matches then , it will take the respective value from column G of >> sheet 2 and will pop in column F of sheet1. >> >> >> Anyhelp will be highly appreciated. >> >> Thanks and regards, >> Smriti >> >> -- >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> >> -- >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
