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 saying:

• look n10 in rolledsteel list
• if it's there, you'll number back, isnumber true, sum
• if it's not, you'll error, isnumber false, return "false"

hope makes sense , trick