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!!
Bookmarks