Hi Prakash

Look in the Excel help for the Vlookup function

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Prakash" wrote in message ...
I am trying to link the information from a table to the invoice. How can I do it?. For an example, Create a drop down menu in one
of the column in the invoice, which information should be extracted from the table's certain coulmn. On the next column of the
invoice again create a drop domn menu, which information is extracted from a certain row from the table. Then all the other
information such as number of units and price should appear as the matching of the previous two information.

Thnx.......