Challenge No. 107: In a survey, 10 questions were asked to both
a manager and an expert, and they responded
to some of them.
Solved using:Excel (CHOOSECOLS, FILTER, HSTACK), Google Sheets, Power Query (List.PositionOf, List.Transform, Table.AddColumn), Python, Python in Excel, and R.
VLOOKUP
Looks up a value in a column and returns a corresponding value from another column in Excel.
Bottom-Up VLOOKUP Formula
Challenge No. 8: Provide a formula in E3 to perform VLOOKUP from bottom for city given in E2.
Solved using: Python in Excel.
