I created a dynamic file that finds our preferred vendor based upon two drop downs: type (device, oem, vendor and the corresponding "submenu."
In the query results, I'd like to concatenate 'Primary POC' and Title' into one cell- something like "select E,F,G,D,concate( P, " ", Q),R,T,J " ----"P" is the pirmary POC and "Q" is their title
And format and email as text (instead of a clickable email link), and the phone numbers to be consistently 000-000-0000 regardless if it's entered on the dataset tab as (800)555-5555 or 9991239876.
Sample file link: Copy of Preferred Vendors - Imaging/Ultrasound
Current query - I have several within an IF's for the dynamic aspect I'm creating.
Thanks
Josh
In the query results, I'd like to concatenate 'Primary POC' and Title' into one cell- something like "select E,F,G,D,concate( P, " ", Q),R,T,J " ----"P" is the pirmary POC and "Q" is their title
And format and email as text (instead of a clickable email link), and the phone numbers to be consistently 000-000-0000 regardless if it's entered on the dataset tab as (800)555-5555 or 9991239876.
Sample file link: Copy of Preferred Vendors - Imaging/Ultrasound
Current query - I have several within an IF's for the dynamic aspect I'm creating.
Code:
IFERROR(
if(B3=lookupMenus!$F$4,QUERY(dataset!$A$2:$Y,"select E,F,G,D,P,R,T,U,J where B='"&$C3&"' and A=FALSE"),
if(B3=lookupMenus!$H$4,QUERY(dataset!$A$2:$Y,"select B,F,G,D,P,R,T,U,J where E='"&$C3&"' and A=FALSE"),
if(B3=lookupMenus!$J$4,QUERY(dataset!$A$2:$Y,"select B,E,G,D,P,R,T,U,J where F='"&$C3&"' and A=FALSE"),
if(B3=lookupMenus!$L$4,QUERY(dataset!$A$2:$Y,"select B,E,F,D,P,R,T,U,J where G='"&$C3&"' and A=FALSE"),""))))
,"")
Thanks
Josh