Welcome!

Excel lookup formula in smartsheet

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

Find more posts tagged with

Comments

J. Craig Williams

The simplest way is to put your LISTS data into the top or bottom of your sheet. Use hierarchies to collapse it so it doesn't get in your way visually.

Use the LOOKUP function in a similar manner to your VLOOKUP usage.

I hope this helps.

Craig

rbarnes15506

I am very new to SmartSheet. Could you please format the formula showing how it should look in SmartSheet using the into in the lists.png ( the last image file )

Many, many thanks if you can help with this.

Ralph

J. Craig Williams

Ralph,

Try here:

https://help.smartsheet.com/topics/formulas-and-functions

https://help.smartsheet.com/function/lookup

That should get you started.

Craig