I already have a table on another sheet which has some people name and contact number. Is there a way I can create an auto fill on another sheet so when I type or select from a drop down someone’s name it will auto fill B1 and C1 with their details from the table sheet?
See VLOOKUP(). Formula will be like as
=IF(ISERROR(VLOOKUP(A1;<your_source_range>;1;0));"";VLOOKUP(A1;<your_source_range>;2;0))
Cheers for that!
It slipped my mind to use VLOOKUP
I change it a little so its more simplified;
=VLOOKUP(A1,<“Sheet with Table of Data”>, 2) for B1
=VLOOKUP(A1,<“Sheet with Table of Data”>, 3) for C1
Please don’t miss the fourth parameter of the function VLOOKUP(), set it to zero. If at any moment your data is not sorted in ascending order, you will encounter an error!