Forum Discussion
Solved
Value repeats in vlookup
I'm creating a list from other sheet with vlookup formula but sometimes it returns same values as above cell. =VLOOKUP($N$4,Sheet2!$A2:$M50,13,0) I tried INDEX MATCH but the results are same...
See the attached version. The formulas are array formulas that have been confirmed with Ctrl+Shift+Enter, then filled down.
what should i do for that!!
Jayde1710 Not sure I understand what you want to achieve. Can't you just use a filter or, if you are on a modern Excel version, the FILTER function.