On Jan 15, 5:21*pm, CrashOz wrote:
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

You could set it up like that

A1: Inputfield
B1: =indirect("Sheet1!B" & E1)
C1: =indirect("Sheet1!C" & E1)
D1: =indirect("Sheet1!D" & E1)
E1: =MATCH(A1,Sheet1!A:A,0)

hth

Carlo