IF Formula

[Sarath27]

=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,

[binuacs]

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

[Sarath27]

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.

[binuacs]

@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?