Hi Jonny

if you're entering or choosing CODE in column D of the Cost Sheet and want
to populate supplied / description and price you'll need to change (if
possible) the structure of the database so CODE is in column A - if it's not
possible to change we'll have to go for an INDEX/MATCH solution rather than
a VLOOKUP solution.

However assuming you can change it and you have done so then the formula in
column B of the Cost Sheet would be
=VLOOKUP(D2,Database!$A$2:$D$1000,3,0)
- to test, type this -you'll get #NA but don't worry, then copy & paste a
value from the Code column on the Database sheet into cell D2 on the Cost
Sheet ... the associated description should be filled in.

Let us know how you go

Cheers
JulieD



"Jonny" wrote in message
...
Thanks JulieD that sounds like it is what I need but whenever I try
anything
you said it brings up formulae error.

The exact setup is like so:

Database (worksheet)
....A...........B.............C.............D
Supplier - Code - Description - Price

note: codes can be a mixture of letters and numbers (dont know if this
will
matter?)

Cost Sheet (worksheet)
..A............B............C.......D..........F.. ..........G
Item - Description - Qty - Code - Supplier - Price

note: column E is not relevent (its only 2 pixels wide for some reason?)
but
doesnt matter.

Thanks very much for the help