Boston Consulting Group Interview Question

Could tell me how does hlookup function work in excel?