still helpless in knoxville

[casadegeorge]

Thank you for your help.
Although I'm a little confussed when writing my formula.

Could someone help me out with this? I've attached my XL file for
anyone to look at. My problem is with cell A13. I'm wanting to continue
my address in the following cell, with my information provided on Sheet
1. I hope this makes since. I've attached the XL file so any could
look at.

example

when I select which vendor I want to use I would like the information
that I have provided under that vendor in sheet1 to appear on my PO.


+----------------------------------------------------------------+
| Attachment filename: purchase order.xls |
|Download attachment: http://www.exceltip.com/forum/attachment.php?postid=312585|
+----------------------------------------------------------------+

 

[pethsm]

I looked at your sheet, and wonder why a simple lookup in each cell
won't work?

here is an example


+----------------------------------------------------------------+
| Attachment filename: po form.xls |
|Download attachment: http://www.exceltip.com/forum/attachment.php?postid=312653|
+----------------------------------------------------------------+