Excel nested If and VLOOKUP statement -
    i making function following: if information in cell equal information stored in list (in worksheet in same workbook) add cell + cell, if false display false or else.   i'm new excel decade ago did course on visual basic , remember basic principles of of these functions. tried number of different ways have not come works. i've tried nesting vlookup  within if  statements hlookup  , lookup  had no success.    rolledsteel  product list.  list  worksheet contains rolledsteel  (plus other lists).  invoice  worksheet contains functions link rolledsteel  or list .    functions have tried had no success with:   =if(n10=list!$a$2:$g$13,w10+w10,false)  =if(n10=rolledsteel,w10+w10,false)  =if(n10=vlookup(n10,rolledsteel,4,false),w10+w10,false)   i have few more questions ahead resolve issue. appreciated.          i'm thining easiest way using match()  function if(isnumber()  follows:   =if(isnumber(match(n10,rolledsteel,false)),w10+w10,"false")   basically, you're sa...