I have 2 worksheets one with a table that has 500 rows with 4 coloums of data
for each row as per below

Stock Code Stock Name Margin Required Shortable
AAC AUST AG CO FPO 35% Yes
AAB AUST FPO 40% No

on the other worksheet i would like to enter a Stock code, Say "ACC" into a
cell and then the cells beside it auto populate with the "Stock Name",
"Margin" and "Shortable" values that matches to the "Stock Code" entered.

Any help would be great.

Crash