Hi,
It is very simple. Please use below code.
=iferror(VLOOKUP(A2,Sheet2!$A$2:Sheet2!$B$3,2,FALSE)," ")
Regards
Ramesh k
On 17-Apr-2013 2:43 AM, "Barry White" <imtigerwords@yahoo.com> 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]
>
>
>
[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 (12) |
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