Building a UTM based on selections in a form

[J7House1984]

I am building a tool that the user can use to create a UTM based on criteria they have selected. I have created a list validation for 2 fields that depending on which the previous selection. The selection is dynamic so what ever is chosen as a "Channel" then the "Description" list will only populate based off the corresponding "Channel" fields. I've gotten this to work by turning "Channel" and "Description" into tables. The issue I have now is that when I concatenate the website and the correlating result based on another table using a VLOOKUP I get NA#. The formula I am using is as follows:

=B9&VLOOKUP(Channel_Option[Channel]&Description_Option[Description],Concat_Tbl[#All],4,0)

Before I built the tables to get the dynamic selection to work my formula worked. That formula was:

=B9&VLOOKUP(B12&B15,'UTM_TH_Online Appt List'!A$2$:D$13$,4,0)

I can't seem to figure out how to get all this to work together. Please advise as to what I am not doing correctly. I tried to be as descriptive as possible so please let me know if you have any questions and I will try my best to answer them.

 

[J7House1984]

I figured it out on my own. Thank you

 

[Peter_SSs]

Glad to hear you got the solution.

If you would like to post your solution then it is perfectly fine to mark that post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.

 

[J7House1984]

The solution to the issue was the data one of the columns had an extra space in the cell that did not need to be there as well as in the vlookup table array was set as a table and I set it to a range and it that solved the issue.

 

[Peter_SSs]

Thanks for the additional information.