Data validation and autofill adjacent cells help

[keranali]

Hi all I am stuck with a problem I have two data validation list in sheet 1 which E2 and F2 are drop down lists, these validation lists are reading information from sheet 2 col A and Col B. I needed Col F validation list to be dependent of what is chosen col E and automatically populate G H J and L with information from sheet 2 rows G H J and L.

Thanks
K

 

[rs2k]

Have a look at this link;
http://contextures.com/xlDataVal02.html

then use VLOOKUP to populate your cells G H J & L

HTH
Colin

 

[keranali]

Thanks I will try this however do you know of a VBA version code?