question by: Junnie Chen
VLookup Using Partial Values
I have a list of student names and their information in 'Data' sheet. Separately in 'Inquiry' sheet, I want to pull all information for that particular student once user key in the student name partially in cell E3. Currently I am using the formula below to extract the information but it does not work if I key in the name partially.