Vlookups with multiple choices?!?!

Hi All,

I have (with your help) created a series of 3 dropdowns columns that poulate their data depending on what is in the lead column.

However this has confused my vlookup. When the user picks the lead column (in our spreadsheet this is country) the drop downs show all the customers, suppliers and products in the dropdowns.

But for our OLE to work i had a VLookup column looking at the customer name and populating the code (this has to be a in seperate column)
Now i have 3 different sets of data in the dropdowns. However in some of our entities we have the same customer name with a different code in the different entity. The lookup has to pick the right code or the OLE will fail.

Can i have a Vlookup that checks which data to check through. ie
=Vlookup($A$4 (this being the bit it has to identify to pick which list to look at) and then the rest of the function?

I hope this makes sense it is a bit rambling

Thanks in advance!!

Ηι

Be sure attaching a sample of your work and showing what exactly is your goal, you will find much more easily your solution.

Hi

I think that your sample is not understood. At least to me.
In columns B, C, D, write:

I have got this bit to work but now i need the code

How did you get this information does not appear anywhere.
As far as I understand Customer code, depends on the other 3 columns that does not seem to identify themselves.

As a hurry, I send you a quick proposal (without getting the data I want), do help make your job.