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