1. This website uses cookies to improve service and provide a tailored user experience. By using this site, you agree to this use. See our Cookie Policy.
    Dismiss Notice

[WTH]Excel - Conditionnal Value From others sheet's cells

Discussion in 'Hire a Freelancer' started by HostStage, May 4, 2013.

  1. HostStage

    HostStage Jr. VIP Jr. VIP

    Joined:
    May 20, 2010
    Messages:
    1,975
    Likes Received:
    1,800
    Gender:
    Male
    Occupation:
    Hosting 4 IMer
    Location:
    World
    Home Page:
    Hello,

    I've a specific task to get done on Excel. I'm loosing countless of time because of this manual thing while i know it can be automated.

    Here is in words, what i would need :

    If value from A1(sheet2) exists in C(sheet1), then display B(sheet1), if not display "message"

    This formula needs to be applied only if D1(sheet2) is equal to several custom values, if not let it be.

    Note 1 the value aren't numbers.
    Note 2 the sheets are custom named

    To name the obvious, the formula needs to be extended to the whole A(sheet2) column.

    $5 if simple Excel formula, $10 if VB macro