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.
I can't share the exact data file..but i attached a replicate file.. and I'm still working on 2007 so new Excel formulas not working
See the attached version. The formulas are array formulas that have been confirmed with Ctrl+Shift+Enter, then filled down.
- wow..that formula works..thank you buddy..