Forum Discussion

Tony2021's avatar
Tony2021
Iron Contributor
Dec 21, 2021

Count and Vlookup

Hello Experts,   How could I modify the below that if there is >1 match on the lookup value (B8) and different results  found in the return array (N:N) then it will somehow notify me?  =XLOOKUP(B8...
excel
Tony2021's avatar
Tony2021
Iron Contributor
Dec 25, 2021

Riny_van_Eekelen 

Hello Riny,

Sorry for my tardy reply. I am not completely following but I think if you had a peek at the attached excel it would make more sense what I am after. Let me know if you have any questions. thank you for the help! 

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Dec 26, 2021

Tony2021 Added a formula (in it's roughest form) to the schedule, believing it does what you need.

=IF(COUNTA(UNIQUE(FILTER(C2:C10,B2:B10=B13)))<>1,"Warning",UNIQUE(FILTER(C2:C10,B2:B10=B13)))

You could polish it up by using named ranges, rather than direct cell references. To avoid repeating segments, like UNIQUE(FILTER(.......)), within the formula, consider using the LET function.

Resources