Excel formula for: if value is, then vlookup

  • I want to do a vlookup (referring to a range on another sheet) in a cell, if the value in the preceding cell is "y".

    I have tried =if(B2="y",=vlookup(B1,Clients,3,false),""), where

    B2 is the cell on sheet 2 that I enter y or n
    BI is the cell on Sheet 2 containing the 'trigger' value
    Clients is the named range in Sheet 1
    and 3 is the column on Sheet 1 to look up. But this doesn't work.

    Any suggestions?

    Thank you.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!