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
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
Comments
-
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 -
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
-
Ralph,
Try here:
https://help.smartsheet.com/topics/formulas-and-functions
https://help.smartsheet.com/function/lookup
That should get you started.
Craig
