10 Secods Excel Challenge- Reverse VLOOKUP

Most Excel users believe VLOOKUP cannot search left. In this 10-second Excel challenge, I show a smart trick using VLOOKUP + CHOOSE to find Employee ID when Employee Name is entered — without helper columns. 💡 Formula used: =VLOOKUP(K1,CHOOSE({1,2},B2:B11,A2:A11),2,0) This trick is rare, practical, and office-ready. 📌 Follow for more 10-second Excel challenges 📌 Learn Excel the smart way #ExcelChallenge #10SecondExcel #VLOOKUP #ExcelTips #ExcelShorts #ExcelTricks #OfficeExcel #LearnExcel #ExcelFormula #ReverseLookup