Secure request management Streamline requests, process ticketing, and more.Process management at scale Deliver consistent projects and processes at scale.Content management Organize, manage, and review content production.Workflow automation Quickly automate repetitive tasks and processes.Team collaboration Connect everyone on one collaborative platform.Smartsheet platform Learn how the Smartsheet platform for dynamic work offers a robust set of capabilities to empower everyone to manage projects, automate workflows, and rapidly build solutions at scale.The vlookup in the SearchFor table can then be entered as normal with no joining formulas required within it (see formula below).Ī final scenario could be where both tables have the name columns separate in which case you can either replicate the solution in Scenario 2 (insert a column joining the two name values) in both your WhereToSearch and SearchFor tables. We can then drag this formula down to populate the new column. The vlookup formula on its own can’t do this but a fix is to insert a column after column F and do the same thing as in Scenario 1 above and join the First Name and Surnames together (with a space in between).
In Scenario 2 we want to return a value from the WhereToSearch table on the right into the SearchFor table on the left but the WhereToSearch table inconveniently has the first name and last name in separate columns. You can then drag the formula down column D (in this case for Meggan Mohan) and tada! You have the student numbers automatically filled in. So we can build this into our vlookup formula in the SearchFor part of the formula to be as follows: Joining the values in cells B4 and C4 together (with the space in between) in an excel formula would be What we effectively need to do in the vlookup formula is join these names together (with a space between them) and then do the vlookup as normal. In Scenario 1 we want to return a value from the WhereToSearch table on the right into the SearchFor table on the left but the SearchFor table has the first name and last name in separate columns.
An example would be where you’re looking in the data for a first name + last name combination but your lookup table has them in separate columns (or vice versa – we’ll go through both Sometimes the value that you’re searching for isn’t neatly in one column. Hi, I think this article from might be useful for you.