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

Regards,
Ryan---

--
RyGuy


"redbananaman" wrote:

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