Help with vlook up function

%3CLINGO-SUB%20id%3D%22lingo-sub-320923%22%20slang%3D%22en-US%22%3EHelp%20with%20vlook%20up%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-320923%22%20slang%3D%22en-US%22%3E%3CP%3E%3DIF(ISERROR(VLOOKUP(FM%2416%2Cdaily%2C6%2CFALSE))%2C0%2CVLOOKUP(FM%2416%2Cdaily%2C6%2CFALSE))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethis%20function%20looks%20at%20the%20stock%20ticker%20symbol%20(cell%20FM16)%20and%20provides%20the%20latest%20stock%20price.%3C%2FP%3E%3CP%3EI%20want%20to%20update%20the%20formula%20to%20also%20look%20at%20the%20account%20number%20(in%20cell%20FM18).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%26nbsp%3Bmust%20I%20update%20the%20formula%20to%20pull%20the%20share%20price%20based%20on%20stock%20ticker%20and%20account%20number%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-320923%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

=IF(ISERROR(VLOOKUP(FM$16,daily,6,FALSE)),0,VLOOKUP(FM$16,daily,6,FALSE))

 

this function looks at the stock ticker symbol (cell FM16) and provides the latest stock price.

I want to update the formula to also look at the account number (in cell FM18).

 

How must I update the formula to pull the share price based on stock ticker and account number?

0 Replies