1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

[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 Premium Member UnGagged Attendee

    Joined:
    May 20, 2010
    Messages:
    1,772
    Likes Received:
    1,730
    Occupation:
    BHW - CEO of Webhosting Company
    Location:
    BWH from France
    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