Hi

VLOOKUP(ID,TableName or range,Offset column,O) Zero is the type and will
return #N/A! value if ID is not in in the table.

Look in help for more details.

Peter

"MIK" wrote:

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.