Vlookup for a single column with more than 11 Sheets

Options

System

System Employee Admin

07/31/23 in Formulas and Functions

This discussion was created from comments split from: [UPDATED] Community Reward Program 🏆.

0 ·

Answers

Raghavendra N ✭✭✭

07/30/23
Options
I need help on "how do we put we Vlookup for a single column with multiple sheets" Morethen 11 Sheets

0 · Share on Facebook Share on Twitter
Paul Newcome ✭✭✭✭✭✭

07/31/23
Options
https://community.smartsheet.com/discussion/93420/vlookup-across-multiple-sheets

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Change index/match formula to the value (remove the formula/save the data)
I would like to change the cells in a column (in a worksheet) from a formula that pulled a value from another worksheet to the actual data that was produced by the formula. Is there any quick "convert to value" action? Thank you
Combine Cells from Multiple Rows with Formatting
Hi, I'm using the Meeting Management Template and would like to combine all the agenda items and descriptions into a single cell in the parent row. The end goal is to use the document generator to send the agenda and updates to a pdf so I need to add some formatting. Here is the sheet Here's the end result I'm looking for.…
Collect List of Matching Emails from Selected Items in Dropdown
I have a column that is a dropdown of Names, multiple select enabled. I want to have a second column that another dropdown of the emails associated with those names. I have this: And would like to achieve this, in a separate sheet: The multi-name selection comes from a form, so this needs to be done with some formula,…