Forum Discussion
New Computer and copy of Excel, now VLOOKUP isn't working
Hi All, I used Vlookup all the time. Got a new computer and copy of Excel and now it doesn't work. I've been testing for about 5 hours and narrowed it down to a text issue. Tried the usual getti...
Desertanalyst VLOOKUP has a limitation, it works from Left to Right direction only, and it must start with 1st column.
You may use Match + Index functions for more flexibility.
Try this: =INDEX($C$1:$C$5,MATCH(B3,$B$1:$B$5))