Vlookup within Vlookups

Ricardo I see what you have done.

*correction*

What you have done DOES work.

I don't think I explained myself very well.

Going back to my example, on customer_addresses sheet, if you scroll across to columns AL and AM, these columns are consignee's for customer A (there could be upto 50 columns per customer, then column AO is for customer B etc etc


Thanks
StuartEade