Use if(iserror( along with vlookup
Sent on my BlackBerry® from Vodafone
-----Original Message-----
From: Viraj Moghe <viraj_moghe@hotmail.com>
Sender: ExcelVBA@yahoogroups.com
Date: Wed, 17 Apr 2013 07:55:33
To: ExcelVBA@yahoogroups.com<ExcelVBA@yahoogroups.com>
Reply-To: ExcelVBA@yahoogroups.com
Subject: RE: [ExcelVBA] IF statement with VLOOKUP combined
use iferror along with vlookup
Thanks
Viraj
Sent from my Windows Phone
________________________________
From: Barry White
Sent: 17-4-13 AM 02:43
To: ExcelVBA@yahoogroups.com
Subject: [ExcelVBA] IF statement with VLOOKUP combined
Hello All,
I have the following VLOOKUP that works fine,
=VLOOKUP(A2,Sheet2!$A$2:Sheet2!$B$3,2,FALSE)
However, in Column B, Gross Revenue, starting with B2, whenever the result from the fill in value is #N/A because there is no exact match, I was hoping to display the blank cell rather than the #N/A. I figured out that double quotes can give me the blank cell (""), but I do not know how to wrap this IF statement around the VLOOKUP statement I created.
MRN Gross Rev
123 2000
234 #N/A
345 #N/A
456 3545
Thank you for any help in advance.
Eric Lutz
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
------------------------------------
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ExcelVBA/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ExcelVBA/join
(Yahoo! ID required)
<*> To change settings via email:
ExcelVBA-digest@yahoogroups.com
ExcelVBA-fullfeatured@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
ExcelVBA-unsubscribe@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
Selasa, 16 April 2013
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar