Hi Puttu, Please find attached solved sheet.
Thanks
Mukesh
----- Original Message -----
From: Puttu *
To: excel-macros@googlegroups.com
Cc: Rohan Young
Sent: Friday, February 25, 2011 5:37 PM
Subject: Re: $$Excel-Macros$$ Very Urgent Help required in Excel formula
Attached is the question with attachment. Please help me out
On Fri, Feb 25, 2011 at 5:22 PM, Puttu * <puttu...@gmail.com> wrote:
No Still not working
2678
YES
This is fine
2558
#N/A
This one I want as blank (if the data doesn't match then it should
show blank cell)
2222
#N/A
This one I want as blank (if the data doesn't match then it should
show blank cell)
On Fri, Feb 25, 2011 at 9:48 AM, Rohan Young <rohan.j...@gmail.com> wrote:
Hi Puttu,
it is working well see the attachment, r u sure you are putting right
criteria in your data, pls. send the sample sheet for understanding,
Thanks & Regd
ROHAN
On Thu, Feb 24, 2011 at 8:16 PM, Puttu * <puttu...@gmail.com> wrote:
Team, Please help me on this
On Thu, Feb 24, 2011 at 6:13 PM, Puttu * <puttu...@gmail.com> wrote:
Hi Experts,
I have two questions
1. I am using Vllokup formula =IF(VLOOKUP(C12,Ukey,1,0),"YES", " ")
in this if any error it shows as #N/A, insted of this i want it show as balnk,
how to do this?
2. In Vlookup formula if the result is found in different excel, i
want that sheet name to be visibled in the result
XXX is foun d in Sheet 1, in vlookup result it should show as "Found
in Sheet 1
Your help will be greatly appriciated.
--
Putta
--
----------------------------------------------------------------------------------
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
--
Putta
--
----------------------------------------------------------------------------------
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
--
Putta
--
Putta
--
----------------------------------------------------------------------------------
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
Vlookup_SOLVED_ROHAN.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
