In cell E4, for example, you'd use a vlookup formula... something like
=if($E$3="","",vlookup($E$3,'Supplier'!$A:$D,2,0)) . You would copy that
down to cells E5 and E6, changing the number 2 to 3 and 4, repectively.
(Note that where I've typed Supplier, you need the name of the worksheet
holding your supplier info).

"jbenedik" wrote:

I have a spreadsheet with my supplier names and addresses. I have a pulldown
menu on my Purchase order linked to my supplier spreadsheet in Cell E3. When
I pick the supplier I would like my purchase order to be for I would like the
address phone number and fax number to automatically appear in Cells E4, E5,
and E6. Is there an easy way to make this relation.

My supplier spreadsheet has the supplier name in column A, Address in Column
B, Phone number in Column C and Fax number in Column D.

Is this possible?

Thanks