Can a data validation look for values against another column?

[Magnatolia]

Hi everyone,

I am updating a Purchase Order register and would like the Purchase Order column to show only PO's that are on the master PO list with the same Supplier as in a separate column. Is this feasible?

Thanks!

 

[swayp11]

Is this what you're looking for: https://www.contextures.com/xlDataVal02.html