Forum Discussion
VLOOKUP to return unique values on subsequent matched records
Hello, Microsoft Excel Community. I'm not sure if there is a VLOOKUP formula that will do what I need, but there must be something out in MS formula land to return accurate results for duplicative i...
Hi, Detlef.
I don't understand how to use "FILTER()" with Vlookup - could you please share the syntax?
Thanks,
Simone
I meant use FILTER() instead of VLOOKUP().
https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759?ui=en-US&rs=en-US&ad=US
https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759?ui=en-US&rs=en-US&ad=US
- I appreciate that filtering formula, but I don't want to filter the data to get a subset. It's okay. I was playing around with "countif" and just attached a unique suffix to my violation. As long as I'm sorting in both the source and target tables, I should be associating the correct suffix on each record. Thanks for the quick reply!
