Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

IF Formula

Sarath27
8 - Asteroid
‎07-18-2023 11:15 PM

=IF(IF(AR40832="GOVT",VLOOKUP('Flex data'!AA40832,'Price testing'!C:J,8,0),"")="GB","GB","")

 

Hi All,

 

Can you please explain me the logic in this formula ?

 

I only understand Vlookup here, rest I am confused,

 

Thanks,

 

 

 

Labels:
Reply
0 Likes
3 REPLIES 3
binuacs
21 - Polaris
‎07-18-2023 11:18 PM

@Sarath27 If the Vlookup value is "GB" Then GB else blank

Reply
0 Likes
Sarath27
8 - Asteroid
‎07-18-2023 11:56 PM

IF [Sector]="GOVT" THEN "GB" ELSE "" ENDIF

 

what about vlookup?

what I did was, I just made a vlookup and then applied below formula, but the count is missing. Please correct me if I am wrong.

 

IF [Sector]="GOVT" THEN "GB" ELSE "" ENDIF  - Multi Row formula been used.

Reply
0 Likes
binuacs
21 - Polaris
‎07-19-2023 12:31 AM

@Sarath27 For the lookup functionality you need to either use the Join tool or the Find and Replace tool, can you provide some sample input files and expected output file?

Reply
0 Likes
Copilot AMA
License admin COmmunity Live
Labels
Top Solution Authors
View All