[ExcelVBA] Re: IF statement with VLOOKUP combined

 

What I would use is =IfError(VLOOKUP(A2,Sheet2!$A$2:Sheet2!$B$3,2,FALSE),"")

Dawn Bleuel
Moderator

--- In ExcelVBA@yahoogroups.com, Barry White <imtigerwords@...> wrote:
>
> 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]
>

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (6)

Recent Activity:

• New Members 6

Visit Your Group

----------------------------------
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

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___