hi,

Im not sure how to use a formula for this problem.

On worksheet 1 (daily log) i wish to input a contract number that is asigned
to a reg number which will be inputted.

i.e.

reg order no
yt02hjg ?

the order number is located in either workbook 2 (cars) or workbook 3 (vans)
so i want a formaula that will search both workbooks for the order number and
input it.

hope that makes sence.

cheers