Lookup function is an easy way to search for a value and get the closest corresponding values in your data. Here’s a quick breakdown of the function =Lookup(search key, search range, result range) Search Key - The value you want to search for Search Range - The cell range where the you want the value to be searched Result Range - The range of cells from where the result will be pulled. This is optional and is used when the values to be returned are not included in the search range 🗂Don’t forget to save this for future reference Share it with friend who can use this🤓 #excel #msexcel #exceltips #corporatelife #accounting #elearning #learn #spreadsheet #spreadsheets #worksmart #worklikeaboss #consultinglife