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