May 08 2022 03:36 PM
Hello Experts,
I need to adjust the below to check if A11 and FBL1N_Pmts[[#All],[Vendor]] are "Like". A11 and FBL1N_Pmts[[#All],[Vendor]] are Company Names and sometimes they are spelled a little differently and I think by using Like it will account for those differences.
I know CountIF is the solution but I cant figure out where to place the CountIF.
Grateful for the help. thank you.
=IF(ISNA(VLOOKUP(A11&B11,FBL1N_Pmts[[#All],[Vendor]]&FBL1N_Pmts[[#All],[Reference]],1,FALSE)),"NOT IN FBL1N","IS IN FBL1N")
May 08 2022 04:25 PM
May 08 2022 06:22 PM
May 09 2022 02:10 AM
Wildcards are useful if you want to match part of a string, e.g. "begins with" or "contains", but they won't help with variations in spelling. You might need the Fuzzy Lookup Add-In for Excel
May 09 2022 05:11 AM
thank you Hans.
I have installed it and it looks like I have to join tables to use the fuzzy lookup. I will explore this more. In the meantime, does Countif work well to capture misspellings as too?
May 09 2022 07:33 AM
If the result of COUNTIF is not what you'd expect, that might be caused by a misspelling, but it won't tell you where...
May 09 2022 08:31 AM
May 09 2022 12:30 PM