Take a look at Help on VLOOKUP.

--
Regards
Roger Govier
"
wrote in message ...
I need to fill out an Order worksheet and have the Items listed in the
order
form reflect the date in my Inventory worksheet.

Which function do I use.