Referencing Another Sheet Formula For Text

laura.sandoval

I added a column in a sheet that is sourced from another sheet...it's for text not numbers. Which formula would I use for this one? The source correlates to the site name...I'm a little stuck. Thanks in advance!

Colleen Patterson

@laura.sandoval you have a few options, such as VLookUp, Index and Match, etc, based on how you are wanting it to be utilized and how the formula will trigger.

If you can provide a few more details about the source sheet, the lookup value or matched column that will allow the lookup, I think either myself or another member of the community would be able to get you a formula.

Here are some learning resources on those functions.

https://help.smartsheet.com/function/vlookup

https://help.smartsheet.com/function/index

https://help.smartsheet.com/function/match

laura.sandoval

Hello thanks for your reply! I am stuck with the formula. This is what I have so far (picture attached). The sheet I am referencing (Master Site Contacts Source) has a list of all the sites as well as their sources...how can I fix the formula?