Thursday, August 9, 2018

yogi_Key-in Student First Name In Cell E2 And Pull All Student Information From 'Data' Sheet

Google Spreadsheet   Post  #2484

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Aug-09-2018

question by: Junnie Chen
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/law8Pw5wjLw;context-place=forum/docs
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.

=IF($E$3="","",ARRAYFORMULA(TRANSPOSE(VLOOKUP($E$3,Data!$B$2:$Z$1000,{2},FALSE))))

I've included the sample sheet here. User would need to key in only partially of the name eg. "Alex" instead of full name "Alex Tan Man Man " and i need the rest of the info to be populated automatically. Kindly advise me how to fix this, many thanks!