I removed the Data Validation from PO Tracker column D (Customer Address) and insert the below formula
=INDEX(CONCATENATE('PO Settings'!$E$3:$E$500,", ",'PO Settings'!$F$3:$F$500,", ",'PO Settings'!$G$3:$G$500),MATCH($C14,'PO Settings'!$C$3:$C$500,0))
For C7:C10
=INDEX('PO Settings'!$D$3:$D$500,MATCH($C$6,'PO Settings'!$C$3:$C$500,0))
=INDEX('PO Settings'!$E$3:$E$500,MATCH($C$6,'PO Settings'!$C$3:$C$500,0))
=INDEX('PO Settings'!$F$3:$F$500,MATCH($C$6,'PO Settings'!$C$3:$C$500,0))
=INDEX('PO Settings'!$G$3:$G$500,MATCH($C$6,'PO Settings'!$C$3:$C$500,0))
This is an array formula so do not just press the ENTER key. Press CTRL + SHIFT + ENTER
Bookmarks