[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

    May 20, 2010
    Likes Received:
    BHW - CEO of Webhosting Company
    BWH from France
    Home Page:

    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