How to pull information from another sheet where I want to compare to columns information maybe from


This is the formula I used below which pulls from the first name and last name column to pull a client:

Some of the first names are not the same in each sheet but the name is in the nickname column.

Is there a way to pull the client name by searching from more than one column? so if the name is in the first name, last name, or nickname?

=IFERROR(INDEX(COLLECT({Master DPS Directory Range 1}, {Master DPS Directory Range 2}, First@row, {Master DPS Directory Range 3}, Last@row), 1), "")

The sheet I am pulling from is below:


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!