Home > Excel Tutorial > Get Data From Another Sheet In Excel Using Vlookup / Data Validation List

Get Data From Another Sheet In Excel Using Vlookup / Data Validation List

Get Data To Several Cells In Row From Another Sheets With Vlookup & Data Validation List Methods

As example ,an invoice template is used. Two names are defined.

 =Customers!$A$2:$A65536 ‘Firmalar

      =Products!$A$2:$A$65536   ‘Urunler

Later by selecting the cell F9 in the sample page ,data validation list is created :

vlookup and data validation list

 

That formula has been entered for cell F10 :

=VLOOKUP(F9;Customers!$A$2:$B$65536;2;FALSE)

With Formula ,the value of cell F10  as automatically changes according to drop-down list (F9)

Other data validation list is created for between C20,C30 :

get data vlookup and data validation list

That formula has been entered for between B20,B30 :

=IF(ISERROR(VLOOKUP(C21;Products!$A$2:$E$65536;2;FALSE));””;VLOOKUP(C21;Products!$A$2:$E$65536;2;FALSE))

For between G20,G30 :

=IF(ISERROR(VLOOKUP(C20;Products!$A$2:$E$65536;5;FALSE));””;VLOOKUP(C20;Products!$A$2:$E$65536;5;FALSE))

For between H20,H30 :

=IF(ISERROR(VLOOKUP(C20;Products!$A$2:$E$65536;3;FALSE));””;VLOOKUP(C20;Products!$A$2:$E$65536;3;FALSE))

Can Be Downloaded Template Here

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: