Related Posts
Buying vs. renting...?
Additional Posts in Excel Genius
I have a field in excel that represents the GSID, that I want to concatenate to create a link. Example field GSID is 123-west and the link needs to be www.website/123_west.html for some reason using concatenate with left & right formulas to switch - to _ results in the field throwing an error. Anyone knows of a way to make this work?
What are the most typical models you all build
New to Fishbowl?
unlock all discussions on Fishbowl.
Are those cells in the same number format? Or any extra spaces?
Found my issue. There were multiple lines with the same identifier, each with different lookup values. Thanks for your help
Did you lock the cell reference ranges if you have any in your formula?
Yes all references are locked