Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Excel lookup formula in smartsheet

rbarnes15506
edited 12/09/19 in Archived 2017 Posts

I have a risk register created in excel that has a tab named "lists".  There are lookup formulas in the risk register that references data in the "lists" tab.  Since smartsheet won't let me make tabs to my Register, how can I make the copied formula work.

Here is an example of the formula:

=IF($D4="","",AVERAGE(VLOOKUP($D4,Lists!$K$1:$S$6,9,0),(VLOOKUP($E4,Lists!$L$1:$S$6,8,0))))

I have attached .png files of the register, and the lists

Risk Factor.png

Consequence Rating.png

Probability Rating.png

lists.png

Comments

This discussion has been closed.