Ask Your Question
0

How can I create an auto fill in Calc e.g. In A1 type someones name then B1 and C1 are automatically filled with contact and address

asked 2015-05-26 15:23:47 +0200

Bakagist_Drachí gravatar image

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?

edit retag flag offensive close merge delete

Comments

See VLOOKUP(). Formula will be like as

=IF(ISERROR(VLOOKUP(A1;<your_source_range>;1;0));"";VLOOKUP(A1;<your_source_range>;2;0))

JohnSUN gravatar imageJohnSUN ( 2015-05-26 16:38:01 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2015-05-26 17:53:22 +0200

Bakagist_Drachí gravatar image

updated 2015-05-26 17:59:18 +0200

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

edit flag offensive delete link more

Comments

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!

JohnSUN gravatar imageJohnSUN ( 2015-05-26 21:17:56 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-05-26 15:23:47 +0200

Seen: 108 times

Last updated: May 26 '15