Just found this again. I still do NOT understand your need. Please explain
in detail with examples.
Please use proper definitions
a file is called a workbook. NOT a sheet
a worksheet within a file is called a worksheet.
-----Original Message-----
From: Baby Patel
Sent: Wednesday, August 24, 2011 9:50 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need a Formula or Macro
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
--
----------------------------------------------------------------------------------
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
