Selasa, 16 April 2013

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]

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (9)
Recent Activity:
----------------------------------
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

----------------------------------
.

__,_._,___

Tidak ada komentar:

Posting Komentar