Help with vlook up function

Copper Contributor

=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