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