Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
326
Views
Topic starter
=IF(AB2="Closed",IFNA(VLOOKUP(AC2,RM2.0_v8!B$2:C$21,2,FALSE),"Unknown-Closed"), VLOOKUP(AB2, RM2.0_v8 F$2:G$17,2,FALSE))
Not able to return the correct list of values with duplicating the entire reference list for each match.
Posted : 12/01/2025 10:21 am
Please share your file (press the paper clip icon "Attach Files" below the editor where you write your reply) as it's not clear from your question alone what you intend to achieve. Remove/replace any private and confidential information, though.
As a general comment, though, VLOOKUP can't return a list of matching values. Only the first one found. So perhaps you need to think of a different approach.
Posted : 12/01/2025 4:37 pm
