Wednesday, January 27, 2016

Get Data From Another Sheet Using Vlookup / Data Validation List

Bring Data From Another Sheet Using Vlookup / Data Validation List

   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 :



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 :

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))


No comments:

Post a Comment