Hi,

I have vendors information on sheet #1. Each vendor has its numerical ID.
Info such as address , city, State, Tel, Fax are in the same row in separate
cells. On sheet # 2, I want to create a form that will require all of the
above info in differnt cells. Is there a way that on my form, if i enter the
ID#, the othe cells will get address, tel, fax etc. from sheet #1.