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

Louis.Smith

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:

Itai Perez

Hey @Louis.Smith,

Have you tried a nested Vlookup?

You can try IFERROR(VLOOKUP(),IFERROR(VLOOKUP())

This will search the First Name column, if it doesnt find a match it will search the Last Name column and you can add another for the nick name.

The issue would be that if you have 2 last names that are the same (Anderson in your list) you will always get the first one (in Anderson it doesnt matter because its the same client).

I hope that helps,

If you need help with the syntex let me know.

I would recommend to correct the list of names then maybe join them to create a unique First, Last, Nickname coulmn where every row in unique but I know that can be difficult to achive sometimes.

Louis.Smith

https://community.smartsheet.com/discussion/comment/385203#Comment_385203

is there a way to do search for first name and last name, if it doesn't find the first name to search in the nickname column?

Paul Newcome

I believe this has already been answered here:

https://community.smartsheet.com/discussion/comment/385360#Comment_385360