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...