Hey Pecoflyer! Thank you for the responds!

I attached a sample, please note -

Sheet 1 - Display all Clients orders, and the order numbers and vale
Sheet 2 - Display all Clients Invoices, and Invoice numbers and value
Sheet 3 - Payments sheet, here is where i need your help:
i have the following scenario -
A. Choose Client name (From droplist)
B. Choose Document Type - Orders or Invoices (From Droplist)

C. Show the relevant Order numbers or Invoice Numbers (in a drop list) according to the Client & Document type - Issue!

So in sheet 3, i trying to get the relevant numbers (in droplist) based on Client name in cell A2 + Type in cell E2.

if Type = "PI", then i would like to get all the PI numbers of the relevant client from sheet 1.
if Type = "Invoice", then i would like to get all the Invoice numbers of the relevant client from sheet 2.

Hope i am clear enough

Thank you in advance for your help!

Link to sample file -
https://www.dropbox.com/s/fe55zl98wx...file.xlsx?dl=0