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.
Jayde1710 That's because VLOOKUP returns the first match. You lookup array shifts down one row for every cell in N. When the firs row of the lookup range is row 9 in Sheet2 (i.e. in cell N12 of Sheet1), the first match for 15021 is found on row 10 (941). Then, in N13, the first match is again on row 10. Thus, a repetition of the previous row.
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.