Formula Help

[Guest]

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

 

[Guest]

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).

 

[L. Howard Kittle]

Try this.

Select the three cells, E4, E5, E6 and while still selected type in:

=VLOOKUP(E3,THE_RANGE,{2,3,4},0)

Now array enter, using CTRL + SHIFT + ENTER.

Where The_range is the lookup array on your supplier sheet.

To make any changes to the formula, you will have to select all three cells
and make the changes in the formula bar and hit ctrl + shift + enter.

HTH
Regards,
Howard