Multiple lists and vlookup

[redbananaman]

Hi,

OK, I have two lists created in separate cells one containing a store number
and the other containing the store name. by selecting either of these I want
to fill another cell with the store name and address zip code etc....I can do
this easily for one drop down list by using VLOOKUP...is it possible to do it
by using either drop down list? if so how do I do it? nested 'if then...'
Vlookups?

Thanks

 

[ryguy7272]

This will work better for you than a Vlookup:
http://www.freefilehosting.net/download/3f204
Adapt to your needs...

Regards,
Ryan---

 

[ryguy7272]

Here is another:
http://www.freefilehosting.net/download/3f209

Regards,
Ryan---