Vlookup within Vlookups

StuartEade,

This can be done, but first do this for us.

Clean up your WB. It looks terrible and this makes it hard to give you a suitable solution.

Solved.

I reworked your WB even more to make it less complicated.

Use two NAMED ranges
Contacts

=OFFSET(customer_addresses!H1,MATCH(Sheet1!$M$6,customer_addresses!A:A,0)-1,0,1,COUNTA(OFFSET(customer_addresses!H1,Sheet1!M17,1,500)))

and Consignees

=OFFSET(Consignee!$A$1,MATCH(Sheet1!$M$6&"*",Consignee!$A$1:$A$1000,0),0,COUNTIF(Consignee!$A$1:$A$1000,"Client 1" & "*"))

Small error in Contacts

=OFFSET(customer_addresses!$H$1,MATCH(Sheet1!$M$6,customer_addresses!A:A,0)-1,0,1,COUNTA(OFFSET(customer_addresses!$H$1,MATCH(Sheet1!$M$6,customer_addresses!A:A,0)-1,0,1,100)))

Please use new attachement

Thankyou thankyou thankyou Ricardo!

Works great.
One thing though.

On the consignee sheet you have done, client 1 may have 20 consignee's, client 2 may have 20, client 3 may have 50.
This causes a problem.
Any solution?


Thankyou
StuartEade