How to use VLOOKUP for columns with indentation?

shubhangia

shubhangia ✭✭

09/20/21 in Smartsheet Basics

Hi, I am not able to use VLOOKUP on the column which has indentation in another sheet, is there a way out I can search and match in the column with indentation

0 ·

Answers

Paul Newcome Community Champion

09/20/21

You should be able to. Exactly what are you trying to do? Are you able to provide screenshots for reference?

CERTIFIED SMARTSHEET PLATINUM PARTNER
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Training opportunities with my team and I
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Mobile number verification on smartsheet forms wont access Saudi Numbers
hi all, I have a form setup on smartsheet, where we require mobile numbers. Today there is an update on forms UI, apparently Saudi Mobile numbers are not accepted: Correct format should be: +966 50 111 11 11 Did anyone face such an issue? How can I resolve it? Many thanks in advance!
Need automations in Expanded Sheet of Table View
I am VERY excited about the release of both Table View with expanded capacity for rows and cells, and the integration of Column Links into that sheet type. It will address several applications that required painful workarounds when constraints of the conventional grid format sheets reached a variety of constraints. Each…
Looking for Tips on Building Smartsheet Buy-In
Hi everyone, Our department is still relatively new to Smartsheet, and overall, the rollout has gone well — most team members have been enthusiastic and quick to get on board. We’ve also had a few internal champions who’ve helped drive early adoption, which has been a big help. That said, we’re seeing a bit of hesitation…

woman with hands out and open

Help shape the future of Smartsheet.
Share your ideas and feature requests.

Watch video<